Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>Unnamed: 0</th>\n",
       "      <th>date</th>\n",
       "      <th>serial_number</th>\n",
       "      <th>model</th>\n",
       "      <th>capacity_bytes</th>\n",
       "      <th>failure</th>\n",
       "      <th>days_before_failure</th>\n",
       "      <th>smart_1_raw</th>\n",
       "      <th>smart_2_raw</th>\n",
       "      <th>smart_3_raw</th>\n",
       "      <th>...</th>\n",
       "      <th>smart_224_raw</th>\n",
       "      <th>smart_225_raw</th>\n",
       "      <th>smart_226_raw</th>\n",
       "      <th>smart_240_raw</th>\n",
       "      <th>smart_241_raw</th>\n",
       "      <th>smart_242_raw</th>\n",
       "      <th>smart_250_raw</th>\n",
       "      <th>smart_251_raw</th>\n",
       "      <th>smart_252_raw</th>\n",
       "      <th>smart_254_raw</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ0351YNG9Z0XA</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.725550</td>\n",
       "      <td>0.160161</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z305B2QN</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.175424</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.133231e-314</td>\n",
       "      <td>-2.386792e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ0351YNG9Z7LA</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.637753</td>\n",
       "      <td>0.184031</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ0351YNGABYAA</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.637753</td>\n",
       "      <td>0.129866</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>WD-WMC4N2899475</td>\n",
       "      <td>WDC WD30EFRX</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.402235</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0        date    serial_number                    model  \\\n",
       "0           0  2016-01-01   MJ0351YNG9Z0XA  Hitachi HDS5C3030ALA630   \n",
       "1           1  2016-01-01         Z305B2QN              ST4000DM000   \n",
       "2           2  2016-01-01   MJ0351YNG9Z7LA  Hitachi HDS5C3030ALA630   \n",
       "3           3  2016-01-01   MJ0351YNGABYAA  Hitachi HDS5C3030ALA630   \n",
       "4           4  2016-01-01  WD-WMC4N2899475             WDC WD30EFRX   \n",
       "\n",
       "   capacity_bytes  failure  days_before_failure  smart_1_raw  smart_2_raw  \\\n",
       "0   1.482490e-311        0                  0.0    -0.856877     0.725550   \n",
       "1   1.976651e-311        0                  0.0    -0.175424     0.000000   \n",
       "2   1.482490e-311        0                  0.0    -0.856877     0.637753   \n",
       "3   1.482490e-311        0                  0.0    -0.856877     0.637753   \n",
       "4   1.482490e-311        0                  0.0    -0.856877     0.000000   \n",
       "\n",
       "   smart_3_raw      ...        smart_224_raw  smart_225_raw  smart_226_raw  \\\n",
       "0     0.160161      ...                  0.0            0.0            0.0   \n",
       "1    -0.335587      ...                  0.0            0.0            0.0   \n",
       "2     0.184031      ...                  0.0            0.0            0.0   \n",
       "3     0.129866      ...                  0.0            0.0            0.0   \n",
       "4     5.402235      ...                  0.0            0.0            0.0   \n",
       "\n",
       "   smart_240_raw  smart_241_raw  smart_242_raw  smart_250_raw  smart_251_raw  \\\n",
       "0 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0            0.0   \n",
       "1 -5.341058e-311 -5.133231e-314 -2.386792e-313            0.0            0.0   \n",
       "2 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0            0.0   \n",
       "3 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0            0.0   \n",
       "4 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0            0.0   \n",
       "\n",
       "   smart_252_raw  smart_254_raw  \n",
       "0            0.0            0.0  \n",
       "1            0.0            0.0  \n",
       "2            0.0            0.0  \n",
       "3            0.0            0.0  \n",
       "4            0.0            0.0  \n",
       "\n",
       "[5 rows x 50 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "data = pd.read_csv('./Data/Clean/clean_data.csv')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.loc[data['failure'] == 1, 'days_before_failure'] = -1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Unnamed: 0</th>\n",
       "      <th>date</th>\n",
       "      <th>serial_number</th>\n",
       "      <th>model</th>\n",
       "      <th>capacity_bytes</th>\n",
       "      <th>failure</th>\n",
       "      <th>days_before_failure</th>\n",
       "      <th>smart_1_raw</th>\n",
       "      <th>smart_2_raw</th>\n",
       "      <th>smart_3_raw</th>\n",
       "      <th>...</th>\n",
       "      <th>smart_224_raw</th>\n",
       "      <th>smart_225_raw</th>\n",
       "      <th>smart_226_raw</th>\n",
       "      <th>smart_240_raw</th>\n",
       "      <th>smart_241_raw</th>\n",
       "      <th>smart_242_raw</th>\n",
       "      <th>smart_250_raw</th>\n",
       "      <th>smart_251_raw</th>\n",
       "      <th>smart_252_raw</th>\n",
       "      <th>smart_254_raw</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>800</th>\n",
       "      <td>800</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z300GQ94</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.306584</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>5.471058e-314</td>\n",
       "      <td>8.262951e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>801</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z300GQ95</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.567308</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.761200e-310</td>\n",
       "      <td>9.123823e-314</td>\n",
       "      <td>4.069550e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>802</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z300GQ93</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.598167</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.203129e-309</td>\n",
       "      <td>8.651095e-314</td>\n",
       "      <td>4.108129e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803</th>\n",
       "      <td>803</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z300GQ90</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.197178</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>5.391076e-314</td>\n",
       "      <td>8.326822e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>804</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z300GQ91</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.969639</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.228631e-311</td>\n",
       "      <td>7.022340e-314</td>\n",
       "      <td>4.444223e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>805</th>\n",
       "      <td>805</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>S300Z45B</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.722862</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>3.835483e-314</td>\n",
       "      <td>-2.314801e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>806</th>\n",
       "      <td>806</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL2331LAGUGXNJ</td>\n",
       "      <td>HGST HMS5C4040ALE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.549957</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>807</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>WD-WXU1E83UUNF8</td>\n",
       "      <td>WDC WD5000LPVX</td>\n",
       "      <td>2.470861e-312</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.002932</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>808</th>\n",
       "      <td>808</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL1311LAG1ZK6A</td>\n",
       "      <td>Hitachi HDS5C4040ALE630</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.506058</td>\n",
       "      <td>0.178522</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>809</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>JK11A8B9JR09WF</td>\n",
       "      <td>Hitachi HDS722020ALA330</td>\n",
       "      <td>9.883284e-312</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856058</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.234523</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>810</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z305D6E1</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.246541</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.133368e-314</td>\n",
       "      <td>-2.386782e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>811</th>\n",
       "      <td>811</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z3015C7W</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.371828</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>5.048035e-314</td>\n",
       "      <td>6.654714e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>812</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ1321YNG1GNZA</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.183112</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>813</th>\n",
       "      <td>813</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z300MZP5</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.740345</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>3.564568e-314</td>\n",
       "      <td>8.961053e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>814</th>\n",
       "      <td>814</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MK0311YHGL3H3A</td>\n",
       "      <td>Hitachi HDS723030ALA640</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.814305</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.247376</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>815</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL2311LAG1N1BC</td>\n",
       "      <td>Hitachi HDS5C4040ALE630</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.549957</td>\n",
       "      <td>0.173932</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>816</th>\n",
       "      <td>816</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z301N2J5</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.294502</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>1.341950e-314</td>\n",
       "      <td>2.815846e-314</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>817</th>\n",
       "      <td>817</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z304KC78</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.012800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-1.354701e-314</td>\n",
       "      <td>-2.370914e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>818</th>\n",
       "      <td>818</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL1331LAGM1Z3H</td>\n",
       "      <td>HGST HMS5C4040BLE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.703601</td>\n",
       "      <td>0.176686</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>819</th>\n",
       "      <td>819</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>W300J6N1</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.686244</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.662160e-310</td>\n",
       "      <td>6.612481e-314</td>\n",
       "      <td>1.068677e-312</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>820</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL1331LAGTX4LH</td>\n",
       "      <td>HGST HMS5C4040ALE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.637753</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>821</th>\n",
       "      <td>821</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>JK11A5B8J1Y4JX</td>\n",
       "      <td>Hitachi HDS722020ALA330</td>\n",
       "      <td>9.883284e-312</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.854420</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.242786</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>822</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z304KC72</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.097816</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>1.603537e-314</td>\n",
       "      <td>-2.136914e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823</th>\n",
       "      <td>823</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ0351YNGA6M8A</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.637753</td>\n",
       "      <td>0.142718</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>824</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>S300VL06</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.885484</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>3.642919e-314</td>\n",
       "      <td>-2.316560e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>825</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>S300VL07</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.684068</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>3.600942e-314</td>\n",
       "      <td>-2.320363e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>826</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z305B70X</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.168599</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.133440e-314</td>\n",
       "      <td>-2.386793e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>827</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>JK11A8B9J364NF</td>\n",
       "      <td>Hitachi HDS722020ALA330</td>\n",
       "      <td>9.883284e-312</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.195047</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>828</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z304KC74</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.819310</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-1.261435e-314</td>\n",
       "      <td>-2.371699e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>829</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z305APC0</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.043072</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.029718e-314</td>\n",
       "      <td>-2.386963e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</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>870</th>\n",
       "      <td>870</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL1331LAGTAUKH</td>\n",
       "      <td>HGST HMS5C4040ALE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.571906</td>\n",
       "      <td>0.117013</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>871</th>\n",
       "      <td>871</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>S300WPY6</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.986641</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>4.786908e-314</td>\n",
       "      <td>-2.129807e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>872</th>\n",
       "      <td>872</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL1331LAGB4EVH</td>\n",
       "      <td>Hitachi HDS5C4040ALE630</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.484109</td>\n",
       "      <td>0.138128</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>873</th>\n",
       "      <td>873</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL1331LAGR6LWH</td>\n",
       "      <td>HGST HMS5C4040ALE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.725550</td>\n",
       "      <td>0.075700</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>874</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z302CXQ8</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.792596</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>9.574130e-314</td>\n",
       "      <td>-1.064408e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>875</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ1311YNG3E7KA</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.177604</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876</th>\n",
       "      <td>876</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>WD-WCC4N0282814</td>\n",
       "      <td>WDC WD30EFRX</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.478433</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>877</th>\n",
       "      <td>877</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL1331LAGSHVLH</td>\n",
       "      <td>HGST HMS5C4040ALE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.549957</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>878</th>\n",
       "      <td>878</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z3058WTK</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.163811</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.133390e-314</td>\n",
       "      <td>-2.387100e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>879</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z304HSB1</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.661838</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-2.863014e-314</td>\n",
       "      <td>-2.378744e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>880</th>\n",
       "      <td>880</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>JK1171YAK1XGSN</td>\n",
       "      <td>Hitachi HDS722020ALA330</td>\n",
       "      <td>9.883284e-312</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.240950</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>881</th>\n",
       "      <td>881</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z304HQR4</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.629621</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-1.411370e-314</td>\n",
       "      <td>-2.372891e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>882</th>\n",
       "      <td>882</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL2331LAGSTVDJ</td>\n",
       "      <td>HGST HMS5C4040ALE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.528008</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>883</th>\n",
       "      <td>883</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>W300TH84</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.574801</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>5.221718e-314</td>\n",
       "      <td>6.133212e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>884</th>\n",
       "      <td>884</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z4D0623M</td>\n",
       "      <td>ST6000DX000</td>\n",
       "      <td>2.964974e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.644953</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.303543e-310</td>\n",
       "      <td>1.057275e-313</td>\n",
       "      <td>-2.088865e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>885</th>\n",
       "      <td>885</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MK0301YHGM4K4A</td>\n",
       "      <td>Hitachi HDS723030ALA640</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.176821</td>\n",
       "      <td>0.254720</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>886</th>\n",
       "      <td>886</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>JK1101B9JBPA6T</td>\n",
       "      <td>Hitachi HDS722020ALA330</td>\n",
       "      <td>9.883284e-312</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.198719</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>887</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>JK1101B9JNN3GF</td>\n",
       "      <td>Hitachi HDS722020ALA330</td>\n",
       "      <td>9.883284e-312</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.235441</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>888</th>\n",
       "      <td>888</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL1331LAGTUWJH</td>\n",
       "      <td>HGST HMS5C4040ALE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.549957</td>\n",
       "      <td>0.048159</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>889</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z3029B22</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.339366</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>2.705054e-314</td>\n",
       "      <td>4.827259e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>890</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z4D02HV1</td>\n",
       "      <td>ST6000DX000</td>\n",
       "      <td>2.964974e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.916751</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.460570e-310</td>\n",
       "      <td>5.689455e-314</td>\n",
       "      <td>1.741775e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>891</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>PL2331LAGST0DJ</td>\n",
       "      <td>HGST HMS5C4040ALE640</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.549957</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>892</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>S301NEGE</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.319005</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>1.620314e-314</td>\n",
       "      <td>-2.351233e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>893</th>\n",
       "      <td>893</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ0351YNGA3AMA</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.725550</td>\n",
       "      <td>0.173932</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>894</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z3029B2J</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.200760</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>4.604985e-314</td>\n",
       "      <td>3.146781e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>895</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ0351YNG9Z8AA</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>0.725550</td>\n",
       "      <td>0.193211</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>896</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z305ANYT</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.204950</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.133315e-314</td>\n",
       "      <td>-2.386780e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>897</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>JK1101B8JP9HKZ</td>\n",
       "      <td>Hitachi HDS722020ALA330</td>\n",
       "      <td>9.883284e-312</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.237278</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>898</th>\n",
       "      <td>898</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>MJ1311YNG08PSA</td>\n",
       "      <td>Hitachi HDS5C3030ALA630</td>\n",
       "      <td>1.482490e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.856877</td>\n",
       "      <td>-1.644958</td>\n",
       "      <td>0.183112</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>-5.480027e-314</td>\n",
       "      <td>-2.399961e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>899</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>Z3029B2C</td>\n",
       "      <td>ST4000DM000</td>\n",
       "      <td>1.976651e-311</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.865549</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.335587</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.341058e-311</td>\n",
       "      <td>6.551172e-314</td>\n",
       "      <td>-1.439916e-313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0        date    serial_number                    model  \\\n",
       "800         800  2016-01-01         Z300GQ94              ST4000DM000   \n",
       "801         801  2016-01-01         Z300GQ95              ST4000DM000   \n",
       "802         802  2016-01-01         Z300GQ93              ST4000DM000   \n",
       "803         803  2016-01-01         Z300GQ90              ST4000DM000   \n",
       "804         804  2016-01-01         Z300GQ91              ST4000DM000   \n",
       "805         805  2016-01-01         S300Z45B              ST4000DM000   \n",
       "806         806  2016-01-01   PL2331LAGUGXNJ     HGST HMS5C4040ALE640   \n",
       "807         807  2016-01-01  WD-WXU1E83UUNF8           WDC WD5000LPVX   \n",
       "808         808  2016-01-01   PL1311LAG1ZK6A  Hitachi HDS5C4040ALE630   \n",
       "809         809  2016-01-01   JK11A8B9JR09WF  Hitachi HDS722020ALA330   \n",
       "810         810  2016-01-01         Z305D6E1              ST4000DM000   \n",
       "811         811  2016-01-01         Z3015C7W              ST4000DM000   \n",
       "812         812  2016-01-01   MJ1321YNG1GNZA  Hitachi HDS5C3030ALA630   \n",
       "813         813  2016-01-01         Z300MZP5              ST4000DM000   \n",
       "814         814  2016-01-01   MK0311YHGL3H3A  Hitachi HDS723030ALA640   \n",
       "815         815  2016-01-01   PL2311LAG1N1BC  Hitachi HDS5C4040ALE630   \n",
       "816         816  2016-01-01         Z301N2J5              ST4000DM000   \n",
       "817         817  2016-01-01         Z304KC78              ST4000DM000   \n",
       "818         818  2016-01-01   PL1331LAGM1Z3H     HGST HMS5C4040BLE640   \n",
       "819         819  2016-01-01         W300J6N1              ST4000DM000   \n",
       "820         820  2016-01-01   PL1331LAGTX4LH     HGST HMS5C4040ALE640   \n",
       "821         821  2016-01-01   JK11A5B8J1Y4JX  Hitachi HDS722020ALA330   \n",
       "822         822  2016-01-01         Z304KC72              ST4000DM000   \n",
       "823         823  2016-01-01   MJ0351YNGA6M8A  Hitachi HDS5C3030ALA630   \n",
       "824         824  2016-01-01         S300VL06              ST4000DM000   \n",
       "825         825  2016-01-01         S300VL07              ST4000DM000   \n",
       "826         826  2016-01-01         Z305B70X              ST4000DM000   \n",
       "827         827  2016-01-01   JK11A8B9J364NF  Hitachi HDS722020ALA330   \n",
       "828         828  2016-01-01         Z304KC74              ST4000DM000   \n",
       "829         829  2016-01-01         Z305APC0              ST4000DM000   \n",
       "..          ...         ...              ...                      ...   \n",
       "870         870  2016-01-01   PL1331LAGTAUKH     HGST HMS5C4040ALE640   \n",
       "871         871  2016-01-01         S300WPY6              ST4000DM000   \n",
       "872         872  2016-01-01   PL1331LAGB4EVH  Hitachi HDS5C4040ALE630   \n",
       "873         873  2016-01-01   PL1331LAGR6LWH     HGST HMS5C4040ALE640   \n",
       "874         874  2016-01-01         Z302CXQ8              ST4000DM000   \n",
       "875         875  2016-01-01   MJ1311YNG3E7KA  Hitachi HDS5C3030ALA630   \n",
       "876         876  2016-01-01  WD-WCC4N0282814             WDC WD30EFRX   \n",
       "877         877  2016-01-01   PL1331LAGSHVLH     HGST HMS5C4040ALE640   \n",
       "878         878  2016-01-01         Z3058WTK              ST4000DM000   \n",
       "879         879  2016-01-01         Z304HSB1              ST4000DM000   \n",
       "880         880  2016-01-01   JK1171YAK1XGSN  Hitachi HDS722020ALA330   \n",
       "881         881  2016-01-01         Z304HQR4              ST4000DM000   \n",
       "882         882  2016-01-01   PL2331LAGSTVDJ     HGST HMS5C4040ALE640   \n",
       "883         883  2016-01-01         W300TH84              ST4000DM000   \n",
       "884         884  2016-01-01         Z4D0623M              ST6000DX000   \n",
       "885         885  2016-01-01   MK0301YHGM4K4A  Hitachi HDS723030ALA640   \n",
       "886         886  2016-01-01   JK1101B9JBPA6T  Hitachi HDS722020ALA330   \n",
       "887         887  2016-01-01   JK1101B9JNN3GF  Hitachi HDS722020ALA330   \n",
       "888         888  2016-01-01   PL1331LAGTUWJH     HGST HMS5C4040ALE640   \n",
       "889         889  2016-01-01         Z3029B22              ST4000DM000   \n",
       "890         890  2016-01-01         Z4D02HV1              ST6000DX000   \n",
       "891         891  2016-01-01   PL2331LAGST0DJ     HGST HMS5C4040ALE640   \n",
       "892         892  2016-01-01         S301NEGE              ST4000DM000   \n",
       "893         893  2016-01-01   MJ0351YNGA3AMA  Hitachi HDS5C3030ALA630   \n",
       "894         894  2016-01-01         Z3029B2J              ST4000DM000   \n",
       "895         895  2016-01-01   MJ0351YNG9Z8AA  Hitachi HDS5C3030ALA630   \n",
       "896         896  2016-01-01         Z305ANYT              ST4000DM000   \n",
       "897         897  2016-01-01   JK1101B8JP9HKZ  Hitachi HDS722020ALA330   \n",
       "898         898  2016-01-01   MJ1311YNG08PSA  Hitachi HDS5C3030ALA630   \n",
       "899         899  2016-01-01         Z3029B2C              ST4000DM000   \n",
       "\n",
       "     capacity_bytes  failure  days_before_failure  smart_1_raw  smart_2_raw  \\\n",
       "800   1.976651e-311        0                  0.0    -0.306584     0.000000   \n",
       "801   1.976651e-311        0                  0.0    -0.567308     0.000000   \n",
       "802   1.976651e-311        0                  0.0    -0.598167     0.000000   \n",
       "803   1.976651e-311        0                  0.0     0.197178     0.000000   \n",
       "804   1.976651e-311        0                  0.0     0.969639     0.000000   \n",
       "805   1.976651e-311        0                  0.0     1.722862     0.000000   \n",
       "806   1.976651e-311        0                  0.0    -0.856877     0.549957   \n",
       "807   2.470861e-312        0                  0.0    -0.856877     0.000000   \n",
       "808   1.976651e-311        0                  0.0    -0.856877     0.506058   \n",
       "809   9.883284e-312        0                  0.0    -0.856058    -1.644958   \n",
       "810   1.976651e-311        0                  0.0    -0.246541     0.000000   \n",
       "811   1.976651e-311        0                  0.0    -0.371828     0.000000   \n",
       "812   1.482490e-311        0                  0.0    -0.856877    -1.644958   \n",
       "813   1.976651e-311        0                  0.0     0.740345     0.000000   \n",
       "814   1.482490e-311        0                  0.0    -0.814305    -1.644958   \n",
       "815   1.976651e-311        0                  0.0    -0.856877     0.549957   \n",
       "816   1.976651e-311        0                  0.0     1.294502     0.000000   \n",
       "817   1.976651e-311        0                  0.0     0.012800     0.000000   \n",
       "818   1.976651e-311        0                  0.0    -0.856877     0.703601   \n",
       "819   1.976651e-311        0                  0.0     1.686244     0.000000   \n",
       "820   1.976651e-311        0                  0.0    -0.856877     0.637753   \n",
       "821   9.883284e-312        0                  0.0    -0.854420    -1.644958   \n",
       "822   1.976651e-311        0                  0.0     2.097816     0.000000   \n",
       "823   1.482490e-311        0                  0.0    -0.856877     0.637753   \n",
       "824   1.976651e-311        0                  0.0     1.885484     0.000000   \n",
       "825   1.976651e-311        0                  0.0     0.684068     0.000000   \n",
       "826   1.976651e-311        0                  0.0    -0.168599     0.000000   \n",
       "827   9.883284e-312        0                  0.0    -0.856877    -1.644958   \n",
       "828   1.976651e-311        0                  0.0    -0.819310     0.000000   \n",
       "829   1.976651e-311        0                  0.0     0.043072     0.000000   \n",
       "..              ...      ...                  ...          ...          ...   \n",
       "870   1.976651e-311        0                  0.0    -0.856877     0.571906   \n",
       "871   1.976651e-311        0                  0.0     1.986641     0.000000   \n",
       "872   1.976651e-311        0                  0.0    -0.856877     0.484109   \n",
       "873   1.976651e-311        0                  0.0    -0.856877     0.725550   \n",
       "874   1.976651e-311        0                  0.0     0.792596     0.000000   \n",
       "875   1.482490e-311        0                  0.0    -0.856877    -1.644958   \n",
       "876   1.482490e-311        0                  0.0    -0.856877     0.000000   \n",
       "877   1.976651e-311        0                  0.0    -0.856877     0.549957   \n",
       "878   1.976651e-311        0                  0.0    -0.163811     0.000000   \n",
       "879   1.976651e-311        0                  0.0     0.661838     0.000000   \n",
       "880   9.883284e-312        0                  0.0    -0.856877    -1.644958   \n",
       "881   1.976651e-311        0                  0.0     1.629621     0.000000   \n",
       "882   1.976651e-311        0                  0.0    -0.856877     0.528008   \n",
       "883   1.976651e-311        0                  0.0    -0.574801     0.000000   \n",
       "884   2.964974e-311        0                  0.0    -0.644953     0.000000   \n",
       "885   1.482490e-311        0                  0.0    -0.856877     0.176821   \n",
       "886   9.883284e-312        0                  0.0    -0.856877    -1.644958   \n",
       "887   9.883284e-312        0                  0.0    -0.856877    -1.644958   \n",
       "888   1.976651e-311        0                  0.0    -0.856877     0.549957   \n",
       "889   1.976651e-311        0                  0.0    -0.339366     0.000000   \n",
       "890   2.964974e-311        0                  0.0     0.916751     0.000000   \n",
       "891   1.976651e-311        0                  0.0    -0.856877     0.549957   \n",
       "892   1.976651e-311        0                  0.0    -0.319005     0.000000   \n",
       "893   1.482490e-311        0                  0.0    -0.856877     0.725550   \n",
       "894   1.976651e-311        0                  0.0    -0.200760     0.000000   \n",
       "895   1.482490e-311        0                  0.0    -0.856877     0.725550   \n",
       "896   1.976651e-311        0                  0.0    -0.204950     0.000000   \n",
       "897   9.883284e-312        0                  0.0    -0.856877    -1.644958   \n",
       "898   1.482490e-311        0                  0.0    -0.856877    -1.644958   \n",
       "899   1.976651e-311        0                  0.0     0.865549     0.000000   \n",
       "\n",
       "     smart_3_raw      ...        smart_224_raw  smart_225_raw  smart_226_raw  \\\n",
       "800    -0.335587      ...                  0.0            0.0            0.0   \n",
       "801    -0.335587      ...                  0.0            0.0            0.0   \n",
       "802    -0.335587      ...                  0.0            0.0            0.0   \n",
       "803    -0.335587      ...                  0.0            0.0            0.0   \n",
       "804    -0.335587      ...                  0.0            0.0            0.0   \n",
       "805    -0.335587      ...                  0.0            0.0            0.0   \n",
       "806    -0.335587      ...                  0.0            0.0            0.0   \n",
       "807     1.002932      ...                  0.0            0.0            0.0   \n",
       "808     0.178522      ...                  0.0            0.0            0.0   \n",
       "809     0.234523      ...                  0.0            0.0            0.0   \n",
       "810    -0.335587      ...                  0.0            0.0            0.0   \n",
       "811    -0.335587      ...                  0.0            0.0            0.0   \n",
       "812     0.183112      ...                  0.0            0.0            0.0   \n",
       "813    -0.335587      ...                  0.0            0.0            0.0   \n",
       "814     0.247376      ...                  0.0            0.0            0.0   \n",
       "815     0.173932      ...                  0.0            0.0            0.0   \n",
       "816    -0.335587      ...                  0.0            0.0            0.0   \n",
       "817    -0.335587      ...                  0.0            0.0            0.0   \n",
       "818     0.176686      ...                  0.0            0.0            0.0   \n",
       "819    -0.335587      ...                  0.0            0.0            0.0   \n",
       "820    -0.335587      ...                  0.0            0.0            0.0   \n",
       "821     0.242786      ...                  0.0            0.0            0.0   \n",
       "822    -0.335587      ...                  0.0            0.0            0.0   \n",
       "823     0.142718      ...                  0.0            0.0            0.0   \n",
       "824    -0.335587      ...                  0.0            0.0            0.0   \n",
       "825    -0.335587      ...                  0.0            0.0            0.0   \n",
       "826    -0.335587      ...                  0.0            0.0            0.0   \n",
       "827     0.195047      ...                  0.0            0.0            0.0   \n",
       "828    -0.335587      ...                  0.0            0.0            0.0   \n",
       "829    -0.335587      ...                  0.0            0.0            0.0   \n",
       "..           ...      ...                  ...            ...            ...   \n",
       "870     0.117013      ...                  0.0            0.0            0.0   \n",
       "871    -0.335587      ...                  0.0            0.0            0.0   \n",
       "872     0.138128      ...                  0.0            0.0            0.0   \n",
       "873     0.075700      ...                  0.0            0.0            0.0   \n",
       "874    -0.335587      ...                  0.0            0.0            0.0   \n",
       "875     0.177604      ...                  0.0            0.0            0.0   \n",
       "876     5.478433      ...                  0.0            0.0            0.0   \n",
       "877    -0.335587      ...                  0.0            0.0            0.0   \n",
       "878    -0.335587      ...                  0.0            0.0            0.0   \n",
       "879    -0.335587      ...                  0.0            0.0            0.0   \n",
       "880     0.240950      ...                  0.0            0.0            0.0   \n",
       "881    -0.335587      ...                  0.0            0.0            0.0   \n",
       "882    -0.335587      ...                  0.0            0.0            0.0   \n",
       "883    -0.335587      ...                  0.0            0.0            0.0   \n",
       "884    -0.335587      ...                  0.0            0.0            0.0   \n",
       "885     0.254720      ...                  0.0            0.0            0.0   \n",
       "886     0.198719      ...                  0.0            0.0            0.0   \n",
       "887     0.235441      ...                  0.0            0.0            0.0   \n",
       "888     0.048159      ...                  0.0            0.0            0.0   \n",
       "889    -0.335587      ...                  0.0            0.0            0.0   \n",
       "890    -0.335587      ...                  0.0            0.0            0.0   \n",
       "891    -0.335587      ...                  0.0            0.0            0.0   \n",
       "892    -0.335587      ...                  0.0            0.0            0.0   \n",
       "893     0.173932      ...                  0.0            0.0            0.0   \n",
       "894    -0.335587      ...                  0.0            0.0            0.0   \n",
       "895     0.193211      ...                  0.0            0.0            0.0   \n",
       "896    -0.335587      ...                  0.0            0.0            0.0   \n",
       "897     0.237278      ...                  0.0            0.0            0.0   \n",
       "898     0.183112      ...                  0.0            0.0            0.0   \n",
       "899    -0.335587      ...                  0.0            0.0            0.0   \n",
       "\n",
       "     smart_240_raw  smart_241_raw  smart_242_raw  smart_250_raw  \\\n",
       "800 -5.341058e-311  5.471058e-314  8.262951e-313            0.0   \n",
       "801  7.761200e-310  9.123823e-314  4.069550e-313            0.0   \n",
       "802  1.203129e-309  8.651095e-314  4.108129e-313            0.0   \n",
       "803 -5.341058e-311  5.391076e-314  8.326822e-313            0.0   \n",
       "804 -1.228631e-311  7.022340e-314  4.444223e-313            0.0   \n",
       "805 -5.341058e-311  3.835483e-314 -2.314801e-313            0.0   \n",
       "806 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "807 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "808 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "809 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "810 -5.341058e-311 -5.133368e-314 -2.386782e-313            0.0   \n",
       "811 -5.341058e-311  5.048035e-314  6.654714e-313            0.0   \n",
       "812 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "813 -5.341058e-311  3.564568e-314  8.961053e-313            0.0   \n",
       "814 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "815 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "816 -5.341058e-311  1.341950e-314  2.815846e-314            0.0   \n",
       "817 -5.341058e-311 -1.354701e-314 -2.370914e-313            0.0   \n",
       "818 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "819  1.662160e-310  6.612481e-314  1.068677e-312            0.0   \n",
       "820 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "821 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "822 -5.341058e-311  1.603537e-314 -2.136914e-313            0.0   \n",
       "823 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "824 -5.341058e-311  3.642919e-314 -2.316560e-313            0.0   \n",
       "825 -5.341058e-311  3.600942e-314 -2.320363e-313            0.0   \n",
       "826 -5.341058e-311 -5.133440e-314 -2.386793e-313            0.0   \n",
       "827 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "828 -5.341058e-311 -1.261435e-314 -2.371699e-313            0.0   \n",
       "829 -5.341058e-311 -5.029718e-314 -2.386963e-313            0.0   \n",
       "..             ...            ...            ...            ...   \n",
       "870 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "871 -5.341058e-311  4.786908e-314 -2.129807e-313            0.0   \n",
       "872 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "873 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "874 -5.341058e-311  9.574130e-314 -1.064408e-313            0.0   \n",
       "875 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "876 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "877 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "878 -5.341058e-311 -5.133390e-314 -2.387100e-313            0.0   \n",
       "879 -5.341058e-311 -2.863014e-314 -2.378744e-313            0.0   \n",
       "880 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "881 -5.341058e-311 -1.411370e-314 -2.372891e-313            0.0   \n",
       "882 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "883 -5.341058e-311  5.221718e-314  6.133212e-313            0.0   \n",
       "884  1.303543e-310  1.057275e-313 -2.088865e-313            0.0   \n",
       "885 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "886 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "887 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "888 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "889 -5.341058e-311  2.705054e-314  4.827259e-313            0.0   \n",
       "890  1.460570e-310  5.689455e-314  1.741775e-313            0.0   \n",
       "891 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "892 -5.341058e-311  1.620314e-314 -2.351233e-313            0.0   \n",
       "893 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "894 -5.341058e-311  4.604985e-314  3.146781e-313            0.0   \n",
       "895 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "896 -5.341058e-311 -5.133315e-314 -2.386780e-313            0.0   \n",
       "897 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "898 -5.341058e-311 -5.480027e-314 -2.399961e-313            0.0   \n",
       "899 -5.341058e-311  6.551172e-314 -1.439916e-313            0.0   \n",
       "\n",
       "     smart_251_raw  smart_252_raw  smart_254_raw  \n",
       "800            0.0            0.0            0.0  \n",
       "801            0.0            0.0            0.0  \n",
       "802            0.0            0.0            0.0  \n",
       "803            0.0            0.0            0.0  \n",
       "804            0.0            0.0            0.0  \n",
       "805            0.0            0.0            0.0  \n",
       "806            0.0            0.0            0.0  \n",
       "807            0.0            0.0            0.0  \n",
       "808            0.0            0.0            0.0  \n",
       "809            0.0            0.0            0.0  \n",
       "810            0.0            0.0            0.0  \n",
       "811            0.0            0.0            0.0  \n",
       "812            0.0            0.0            0.0  \n",
       "813            0.0            0.0            0.0  \n",
       "814            0.0            0.0            0.0  \n",
       "815            0.0            0.0            0.0  \n",
       "816            0.0            0.0            0.0  \n",
       "817            0.0            0.0            0.0  \n",
       "818            0.0            0.0            0.0  \n",
       "819            0.0            0.0            0.0  \n",
       "820            0.0            0.0            0.0  \n",
       "821            0.0            0.0            0.0  \n",
       "822            0.0            0.0            0.0  \n",
       "823            0.0            0.0            0.0  \n",
       "824            0.0            0.0            0.0  \n",
       "825            0.0            0.0            0.0  \n",
       "826            0.0            0.0            0.0  \n",
       "827            0.0            0.0            0.0  \n",
       "828            0.0            0.0            0.0  \n",
       "829            0.0            0.0            0.0  \n",
       "..             ...            ...            ...  \n",
       "870            0.0            0.0            0.0  \n",
       "871            0.0            0.0            0.0  \n",
       "872            0.0            0.0            0.0  \n",
       "873            0.0            0.0            0.0  \n",
       "874            0.0            0.0            0.0  \n",
       "875            0.0            0.0            0.0  \n",
       "876            0.0            0.0            0.0  \n",
       "877            0.0            0.0            0.0  \n",
       "878            0.0            0.0            0.0  \n",
       "879            0.0            0.0            0.0  \n",
       "880            0.0            0.0            0.0  \n",
       "881            0.0            0.0            0.0  \n",
       "882            0.0            0.0            0.0  \n",
       "883            0.0            0.0            0.0  \n",
       "884            0.0            0.0            0.0  \n",
       "885            0.0            0.0            0.0  \n",
       "886            0.0            0.0            0.0  \n",
       "887            0.0            0.0            0.0  \n",
       "888            0.0            0.0            0.0  \n",
       "889            0.0            0.0            0.0  \n",
       "890            0.0            0.0            0.0  \n",
       "891            0.0            0.0            0.0  \n",
       "892            0.0            0.0            0.0  \n",
       "893            0.0            0.0            0.0  \n",
       "894            0.0            0.0            0.0  \n",
       "895            0.0            0.0            0.0  \n",
       "896            0.0            0.0            0.0  \n",
       "897            0.0            0.0            0.0  \n",
       "898            0.0            0.0            0.0  \n",
       "899            0.0            0.0            0.0  \n",
       "\n",
       "[100 rows x 50 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.iloc[,:]"
   ]
  },
  {
   "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.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}