cimcolog.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from pandas import read_excel\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "       monitorid                date  monitortype  monitorport monitortag  \\\n",
      "0        8076509 2019-12-05 01:00:00         4096          271      YLOAD   \n",
      "1        8076511 2019-12-05 01:00:00         4096          271       XPOS   \n",
      "2        8076512 2019-12-05 01:00:00         4096          271       YPOS   \n",
      "3        8076513 2019-12-05 01:00:00         4096          271       ZPOS   \n",
      "4        8076516 2019-12-05 01:00:01         4096          271       XPOS   \n",
      "...          ...                 ...          ...          ...        ...   \n",
      "61837    8297783 2019-12-05 11:59:34         4096          271       TEMP   \n",
      "61838    8297790 2019-12-05 11:59:37         4096          271       ZPOS   \n",
      "61839    8297791 2019-12-05 11:59:37         4096          271       TEMP   \n",
      "61840    8297813 2019-12-05 11:59:41         4096          271       TEMP   \n",
      "61841    8297820 2019-12-05 11:59:42         4096          271       TEMP   \n",
      "\n",
      "                        monitortext  monitorfile  monitorprogram  monitorjob  \\\n",
      "0      Percentage of Max Y-load: 48          NaN          2940.0      2940.0   \n",
      "1               Absolute X-position          NaN          2940.0      2940.0   \n",
      "2               Absolute Y-position          NaN          2940.0      2940.0   \n",
      "3               Absolute Y-position          NaN          2940.0      2940.0   \n",
      "4               Absolute X-position          NaN          2940.0      2940.0   \n",
      "...                             ...          ...             ...         ...   \n",
      "61837                            26          NaN          9271.0      2940.0   \n",
      "61838           Absolute Y-position          NaN          9271.0      2940.0   \n",
      "61839                            25          NaN          9271.0      2940.0   \n",
      "61840                            26          NaN          9271.0      2940.0   \n",
      "61841                            25          NaN             NaN         NaN   \n",
      "\n",
      "      monitoroperator  ...  monitorvar7 monitorvar8 monitorvar9  monitorvar10  \\\n",
      "0                 Kim  ...          NaN         NaN           0             0   \n",
      "1                 Kim  ...          NaN         NaN           0             0   \n",
      "2                 Kim  ...          NaN         NaN           0             0   \n",
      "3                 Kim  ...          NaN         NaN           0             0   \n",
      "4                 Kim  ...          NaN         NaN           0             0   \n",
      "...               ...  ...          ...         ...         ...           ...   \n",
      "61837             Kim  ...          NaN         NaN           0             0   \n",
      "61838             Kim  ...          NaN         NaN           0             0   \n",
      "61839             Kim  ...          NaN         NaN           0             0   \n",
      "61840             Kim  ...          NaN         NaN           0             0   \n",
      "61841             NaN  ...          NaN         NaN           0             0   \n",
      "\n",
      "       monitorvar11  monitorvar12  monitorvar13  monitorvar14  monitorvar15  \\\n",
      "0                 0             0             0             0             0   \n",
      "1                 0             0             0             0             0   \n",
      "2                 0             0             0             0             0   \n",
      "3                 0             0             0             0             0   \n",
      "4                 0             0             0             0             0   \n",
      "...             ...           ...           ...           ...           ...   \n",
      "61837             0             0             0             0             0   \n",
      "61838             0             0             0             0             0   \n",
      "61839             0             0             0             0             0   \n",
      "61840             0             0             0             0             0   \n",
      "61841             0             0             0             0             0   \n",
      "\n",
      "       monitorvar16  \n",
      "0                 0  \n",
      "1                 0  \n",
      "2                 0  \n",
      "3                 0  \n",
      "4                 0  \n",
      "...             ...  \n",
      "61837             0  \n",
      "61838             0  \n",
      "61839             0  \n",
      "61840             0  \n",
      "61841             0  \n",
      "\n",
      "[61842 rows x 27 columns]\n"
     ]
    }
   ],
   "source": [
    "df=pd.read_excel(r'c:\\\\python csv file\\freelance\\CIMCO Log_M1.xlsx')\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "data_xls = pd.read_excel(r\"c:\\\\python csv file\\freelance\\CIMCO Log_M1.xlsx\",  index_col=None)\n",
    "data_xls.to_csv('your_csv.csv', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitortext</th>\n",
       "      <th>monitorfile</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>...</th>\n",
       "      <th>monitorvar7</th>\n",
       "      <th>monitorvar8</th>\n",
       "      <th>monitorvar9</th>\n",
       "      <th>monitorvar10</th>\n",
       "      <th>monitorvar11</th>\n",
       "      <th>monitorvar12</th>\n",
       "      <th>monitorvar13</th>\n",
       "      <th>monitorvar14</th>\n",
       "      <th>monitorvar15</th>\n",
       "      <th>monitorvar16</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8076509</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YLOAD</td>\n",
       "      <td>Percentage of Max Y-load: 48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8076511</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8076512</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8076513</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>8076516</td>\n",
       "      <td>2019-12-05 01:00:01</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61837</td>\n",
       "      <td>61837</td>\n",
       "      <td>8297783</td>\n",
       "      <td>2019-12-05 11:59:34</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61838</td>\n",
       "      <td>61838</td>\n",
       "      <td>8297790</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61839</td>\n",
       "      <td>61839</td>\n",
       "      <td>8297791</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61840</td>\n",
       "      <td>61840</td>\n",
       "      <td>8297813</td>\n",
       "      <td>2019-12-05 11:59:41</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61841</td>\n",
       "      <td>61841</td>\n",
       "      <td>8297820</td>\n",
       "      <td>2019-12-05 11:59:42</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61842 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  monitorid                 date  monitortype  monitorport  \\\n",
       "0               0    8076509  2019-12-05 01:00:00         4096          271   \n",
       "1               1    8076511  2019-12-05 01:00:00         4096          271   \n",
       "2               2    8076512  2019-12-05 01:00:00         4096          271   \n",
       "3               3    8076513  2019-12-05 01:00:00         4096          271   \n",
       "4               4    8076516  2019-12-05 01:00:01         4096          271   \n",
       "...           ...        ...                  ...          ...          ...   \n",
       "61837       61837    8297783  2019-12-05 11:59:34         4096          271   \n",
       "61838       61838    8297790  2019-12-05 11:59:37         4096          271   \n",
       "61839       61839    8297791  2019-12-05 11:59:37         4096          271   \n",
       "61840       61840    8297813  2019-12-05 11:59:41         4096          271   \n",
       "61841       61841    8297820  2019-12-05 11:59:42         4096          271   \n",
       "\n",
       "      monitortag                   monitortext  monitorfile  monitorprogram  \\\n",
       "0          YLOAD  Percentage of Max Y-load: 48          NaN          2940.0   \n",
       "1           XPOS           Absolute X-position          NaN          2940.0   \n",
       "2           YPOS           Absolute Y-position          NaN          2940.0   \n",
       "3           ZPOS           Absolute Y-position          NaN          2940.0   \n",
       "4           XPOS           Absolute X-position          NaN          2940.0   \n",
       "...          ...                           ...          ...             ...   \n",
       "61837       TEMP                            26          NaN          9271.0   \n",
       "61838       ZPOS           Absolute Y-position          NaN          9271.0   \n",
       "61839       TEMP                            25          NaN          9271.0   \n",
       "61840       TEMP                            26          NaN          9271.0   \n",
       "61841       TEMP                            25          NaN             NaN   \n",
       "\n",
       "       monitorjob  ... monitorvar7  monitorvar8 monitorvar9 monitorvar10  \\\n",
       "0          2940.0  ...         NaN          NaN           0            0   \n",
       "1          2940.0  ...         NaN          NaN           0            0   \n",
       "2          2940.0  ...         NaN          NaN           0            0   \n",
       "3          2940.0  ...         NaN          NaN           0            0   \n",
       "4          2940.0  ...         NaN          NaN           0            0   \n",
       "...           ...  ...         ...          ...         ...          ...   \n",
       "61837      2940.0  ...         NaN          NaN           0            0   \n",
       "61838      2940.0  ...         NaN          NaN           0            0   \n",
       "61839      2940.0  ...         NaN          NaN           0            0   \n",
       "61840      2940.0  ...         NaN          NaN           0            0   \n",
       "61841         NaN  ...         NaN          NaN           0            0   \n",
       "\n",
       "       monitorvar11  monitorvar12  monitorvar13  monitorvar14  monitorvar15  \\\n",
       "0                 0             0             0             0             0   \n",
       "1                 0             0             0             0             0   \n",
       "2                 0             0             0             0             0   \n",
       "3                 0             0             0             0             0   \n",
       "4                 0             0             0             0             0   \n",
       "...             ...           ...           ...           ...           ...   \n",
       "61837             0             0             0             0             0   \n",
       "61838             0             0             0             0             0   \n",
       "61839             0             0             0             0             0   \n",
       "61840             0             0             0             0             0   \n",
       "61841             0             0             0             0             0   \n",
       "\n",
       "       monitorvar16  \n",
       "0                 0  \n",
       "1                 0  \n",
       "2                 0  \n",
       "3                 0  \n",
       "4                 0  \n",
       "...             ...  \n",
       "61837             0  \n",
       "61838             0  \n",
       "61839             0  \n",
       "61840             0  \n",
       "61841             0  \n",
       "\n",
       "[61842 rows x 28 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1=pd.read_csv(\"your_csv.csv\")\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitortext</th>\n",
       "      <th>monitorfile</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>monitoroperator</th>\n",
       "      <th>...</th>\n",
       "      <th>monitorvar7</th>\n",
       "      <th>monitorvar8</th>\n",
       "      <th>monitorvar9</th>\n",
       "      <th>monitorvar10</th>\n",
       "      <th>monitorvar11</th>\n",
       "      <th>monitorvar12</th>\n",
       "      <th>monitorvar13</th>\n",
       "      <th>monitorvar14</th>\n",
       "      <th>monitorvar15</th>\n",
       "      <th>monitorvar16</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>8076509</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YLOAD</td>\n",
       "      <td>Percentage of Max Y-load: 48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>8076511</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>8076512</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>8076513</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>8076516</td>\n",
       "      <td>2019-12-05 01:00:01</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            monitorid                 date  monitortype  monitorport  \\\n",
       "Unnamed: 0                                                             \n",
       "0             8076509  2019-12-05 01:00:00         4096          271   \n",
       "1             8076511  2019-12-05 01:00:00         4096          271   \n",
       "2             8076512  2019-12-05 01:00:00         4096          271   \n",
       "3             8076513  2019-12-05 01:00:00         4096          271   \n",
       "4             8076516  2019-12-05 01:00:01         4096          271   \n",
       "\n",
       "           monitortag                   monitortext  monitorfile  \\\n",
       "Unnamed: 0                                                         \n",
       "0               YLOAD  Percentage of Max Y-load: 48          NaN   \n",
       "1                XPOS           Absolute X-position          NaN   \n",
       "2                YPOS           Absolute Y-position          NaN   \n",
       "3                ZPOS           Absolute Y-position          NaN   \n",
       "4                XPOS           Absolute X-position          NaN   \n",
       "\n",
       "            monitorprogram  monitorjob monitoroperator  ...  monitorvar7  \\\n",
       "Unnamed: 0                                              ...                \n",
       "0                   2940.0      2940.0             Kim  ...          NaN   \n",
       "1                   2940.0      2940.0             Kim  ...          NaN   \n",
       "2                   2940.0      2940.0             Kim  ...          NaN   \n",
       "3                   2940.0      2940.0             Kim  ...          NaN   \n",
       "4                   2940.0      2940.0             Kim  ...          NaN   \n",
       "\n",
       "           monitorvar8 monitorvar9  monitorvar10  monitorvar11  monitorvar12  \\\n",
       "Unnamed: 0                                                                     \n",
       "0                  NaN           0             0             0             0   \n",
       "1                  NaN           0             0             0             0   \n",
       "2                  NaN           0             0             0             0   \n",
       "3                  NaN           0             0             0             0   \n",
       "4                  NaN           0             0             0             0   \n",
       "\n",
       "            monitorvar13  monitorvar14  monitorvar15  monitorvar16  \n",
       "Unnamed: 0                                                          \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 27 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.set_index(\"Unnamed: 0\",inplace=True)\n",
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitortext</th>\n",
       "      <th>monitorfile</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>monitoroperator</th>\n",
       "      <th>monitorerrinfo</th>\n",
       "      <th>monitorvar1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>8076509</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YLOAD</td>\n",
       "      <td>Percentage of Max Y-load: 48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>8076511</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>8076512</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>9.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>8076513</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>2.32915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>8076516</td>\n",
       "      <td>2019-12-05 01:00:01</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.3674</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>61837</td>\n",
       "      <td>8297783</td>\n",
       "      <td>2019-12-05 11:59:34</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61838</td>\n",
       "      <td>8297790</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>376.1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61839</td>\n",
       "      <td>8297791</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61840</td>\n",
       "      <td>8297813</td>\n",
       "      <td>2019-12-05 11:59:41</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61841</td>\n",
       "      <td>8297820</td>\n",
       "      <td>2019-12-05 11:59:42</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61842 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            monitorid                 date  monitortype  monitorport  \\\n",
       "Unnamed: 0                                                             \n",
       "0             8076509  2019-12-05 01:00:00         4096          271   \n",
       "1             8076511  2019-12-05 01:00:00         4096          271   \n",
       "2             8076512  2019-12-05 01:00:00         4096          271   \n",
       "3             8076513  2019-12-05 01:00:00         4096          271   \n",
       "4             8076516  2019-12-05 01:00:01         4096          271   \n",
       "...               ...                  ...          ...          ...   \n",
       "61837         8297783  2019-12-05 11:59:34         4096          271   \n",
       "61838         8297790  2019-12-05 11:59:37         4096          271   \n",
       "61839         8297791  2019-12-05 11:59:37         4096          271   \n",
       "61840         8297813  2019-12-05 11:59:41         4096          271   \n",
       "61841         8297820  2019-12-05 11:59:42         4096          271   \n",
       "\n",
       "           monitortag                   monitortext  monitorfile  \\\n",
       "Unnamed: 0                                                         \n",
       "0               YLOAD  Percentage of Max Y-load: 48          NaN   \n",
       "1                XPOS           Absolute X-position          NaN   \n",
       "2                YPOS           Absolute Y-position          NaN   \n",
       "3                ZPOS           Absolute Y-position          NaN   \n",
       "4                XPOS           Absolute X-position          NaN   \n",
       "...               ...                           ...          ...   \n",
       "61837            TEMP                            26          NaN   \n",
       "61838            ZPOS           Absolute Y-position          NaN   \n",
       "61839            TEMP                            25          NaN   \n",
       "61840            TEMP                            26          NaN   \n",
       "61841            TEMP                            25          NaN   \n",
       "\n",
       "            monitorprogram  monitorjob monitoroperator  monitorerrinfo  \\\n",
       "Unnamed: 0                                                               \n",
       "0                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "1                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "2                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "3                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "4                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "...                    ...         ...             ...             ...   \n",
       "61837               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61838               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61839               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61840               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61841                  NaN         NaN             NaN             NaN   \n",
       "\n",
       "           monitorvar1  \n",
       "Unnamed: 0              \n",
       "0                   48  \n",
       "1               35.423  \n",
       "2                 9.29  \n",
       "3              2.32915  \n",
       "4              35.3674  \n",
       "...                ...  \n",
       "61837               26  \n",
       "61838         376.1973  \n",
       "61839               25  \n",
       "61840               26  \n",
       "61841               25  \n",
       "\n",
       "[61842 rows x 12 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.drop(df1.iloc[:, 12:27],axis=1, inplace=True)\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1['date'] = pd.to_datetime(df1.date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitortext</th>\n",
       "      <th>monitorfile</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>monitoroperator</th>\n",
       "      <th>monitorerrinfo</th>\n",
       "      <th>monitorvar1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>8076509</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YLOAD</td>\n",
       "      <td>Percentage of Max Y-load: 48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>8076511</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>8076512</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>9.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>8076513</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>2.32915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>8076516</td>\n",
       "      <td>2019-12-05 01:00:01</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.3674</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>61837</td>\n",
       "      <td>8297783</td>\n",
       "      <td>2019-12-05 11:59:34</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61838</td>\n",
       "      <td>8297790</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>376.1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61839</td>\n",
       "      <td>8297791</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61840</td>\n",
       "      <td>8297813</td>\n",
       "      <td>2019-12-05 11:59:41</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61841</td>\n",
       "      <td>8297820</td>\n",
       "      <td>2019-12-05 11:59:42</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61842 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            monitorid                date  monitortype  monitorport  \\\n",
       "Unnamed: 0                                                            \n",
       "0             8076509 2019-12-05 01:00:00         4096          271   \n",
       "1             8076511 2019-12-05 01:00:00         4096          271   \n",
       "2             8076512 2019-12-05 01:00:00         4096          271   \n",
       "3             8076513 2019-12-05 01:00:00         4096          271   \n",
       "4             8076516 2019-12-05 01:00:01         4096          271   \n",
       "...               ...                 ...          ...          ...   \n",
       "61837         8297783 2019-12-05 11:59:34         4096          271   \n",
       "61838         8297790 2019-12-05 11:59:37         4096          271   \n",
       "61839         8297791 2019-12-05 11:59:37         4096          271   \n",
       "61840         8297813 2019-12-05 11:59:41         4096          271   \n",
       "61841         8297820 2019-12-05 11:59:42         4096          271   \n",
       "\n",
       "           monitortag                   monitortext  monitorfile  \\\n",
       "Unnamed: 0                                                         \n",
       "0               YLOAD  Percentage of Max Y-load: 48          NaN   \n",
       "1                XPOS           Absolute X-position          NaN   \n",
       "2                YPOS           Absolute Y-position          NaN   \n",
       "3                ZPOS           Absolute Y-position          NaN   \n",
       "4                XPOS           Absolute X-position          NaN   \n",
       "...               ...                           ...          ...   \n",
       "61837            TEMP                            26          NaN   \n",
       "61838            ZPOS           Absolute Y-position          NaN   \n",
       "61839            TEMP                            25          NaN   \n",
       "61840            TEMP                            26          NaN   \n",
       "61841            TEMP                            25          NaN   \n",
       "\n",
       "            monitorprogram  monitorjob monitoroperator  monitorerrinfo  \\\n",
       "Unnamed: 0                                                               \n",
       "0                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "1                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "2                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "3                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "4                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "...                    ...         ...             ...             ...   \n",
       "61837               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61838               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61839               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61840               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61841                  NaN         NaN             NaN             NaN   \n",
       "\n",
       "           monitorvar1  \n",
       "Unnamed: 0              \n",
       "0                   48  \n",
       "1               35.423  \n",
       "2                 9.29  \n",
       "3              2.32915  \n",
       "4              35.3674  \n",
       "...                ...  \n",
       "61837               26  \n",
       "61838         376.1973  \n",
       "61839               25  \n",
       "61840               26  \n",
       "61841               25  \n",
       "\n",
       "[61842 rows x 12 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "monitorid                   int64\n",
       "date               datetime64[ns]\n",
       "monitortype                 int64\n",
       "monitorport                 int64\n",
       "monitortag                 object\n",
       "monitortext                object\n",
       "monitorfile               float64\n",
       "monitorprogram            float64\n",
       "monitorjob                float64\n",
       "monitoroperator            object\n",
       "monitorerrinfo            float64\n",
       "monitorvar1                object\n",
       "dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitortext</th>\n",
       "      <th>monitorfile</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>monitoroperator</th>\n",
       "      <th>monitorerrinfo</th>\n",
       "      <th>monitorvar1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            monitorid   date  monitortype  monitorport  monitortag  \\\n",
       "Unnamed: 0                                                           \n",
       "0               False  False        False        False       False   \n",
       "1               False  False        False        False       False   \n",
       "2               False  False        False        False       False   \n",
       "3               False  False        False        False       False   \n",
       "4               False  False        False        False       False   \n",
       "\n",
       "            monitortext  monitorfile  monitorprogram  monitorjob  \\\n",
       "Unnamed: 0                                                         \n",
       "0                 False         True           False       False   \n",
       "1                 False         True           False       False   \n",
       "2                 False         True           False       False   \n",
       "3                 False         True           False       False   \n",
       "4                 False         True           False       False   \n",
       "\n",
       "            monitoroperator  monitorerrinfo  monitorvar1  \n",
       "Unnamed: 0                                                \n",
       "0                     False           False        False  \n",
       "1                     False           False        False  \n",
       "2                     False           False        False  \n",
       "3                     False           False        False  \n",
       "4                     False           False        False  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.isnull().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitortext</th>\n",
       "      <th>monitorfile</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>monitoroperator</th>\n",
       "      <th>monitorerrinfo</th>\n",
       "      <th>monitorvar1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>8076509</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YLOAD</td>\n",
       "      <td>Percentage of Max Y-load: 48</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>8076511</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>8076512</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>9.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>8076513</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>2.32915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>8076516</td>\n",
       "      <td>2019-12-05 01:00:01</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.3674</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>61837</td>\n",
       "      <td>8297783</td>\n",
       "      <td>2019-12-05 11:59:34</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61838</td>\n",
       "      <td>8297790</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>376.1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61839</td>\n",
       "      <td>8297791</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61840</td>\n",
       "      <td>8297813</td>\n",
       "      <td>2019-12-05 11:59:41</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61841</td>\n",
       "      <td>8297820</td>\n",
       "      <td>2019-12-05 11:59:42</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61842 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            monitorid                date  monitortype  monitorport  \\\n",
       "Unnamed: 0                                                            \n",
       "0             8076509 2019-12-05 01:00:00         4096          271   \n",
       "1             8076511 2019-12-05 01:00:00         4096          271   \n",
       "2             8076512 2019-12-05 01:00:00         4096          271   \n",
       "3             8076513 2019-12-05 01:00:00         4096          271   \n",
       "4             8076516 2019-12-05 01:00:01         4096          271   \n",
       "...               ...                 ...          ...          ...   \n",
       "61837         8297783 2019-12-05 11:59:34         4096          271   \n",
       "61838         8297790 2019-12-05 11:59:37         4096          271   \n",
       "61839         8297791 2019-12-05 11:59:37         4096          271   \n",
       "61840         8297813 2019-12-05 11:59:41         4096          271   \n",
       "61841         8297820 2019-12-05 11:59:42         4096          271   \n",
       "\n",
       "           monitortag                   monitortext  monitorfile  \\\n",
       "Unnamed: 0                                                         \n",
       "0               YLOAD  Percentage of Max Y-load: 48          0.0   \n",
       "1                XPOS           Absolute X-position          0.0   \n",
       "2                YPOS           Absolute Y-position          0.0   \n",
       "3                ZPOS           Absolute Y-position          0.0   \n",
       "4                XPOS           Absolute X-position          0.0   \n",
       "...               ...                           ...          ...   \n",
       "61837            TEMP                            26          0.0   \n",
       "61838            ZPOS           Absolute Y-position          0.0   \n",
       "61839            TEMP                            25          0.0   \n",
       "61840            TEMP                            26          0.0   \n",
       "61841            TEMP                            25          0.0   \n",
       "\n",
       "            monitorprogram  monitorjob monitoroperator  monitorerrinfo  \\\n",
       "Unnamed: 0                                                               \n",
       "0                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "1                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "2                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "3                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "4                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "...                    ...         ...             ...             ...   \n",
       "61837               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61838               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61839               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61840               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61841                  0.0         0.0               0    0.000000e+00   \n",
       "\n",
       "           monitorvar1  \n",
       "Unnamed: 0              \n",
       "0                   48  \n",
       "1               35.423  \n",
       "2                 9.29  \n",
       "3              2.32915  \n",
       "4              35.3674  \n",
       "...                ...  \n",
       "61837               26  \n",
       "61838         376.1973  \n",
       "61839               25  \n",
       "61840               26  \n",
       "61841               25  \n",
       "\n",
       "[61842 rows x 12 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "monitorid          False\n",
       "date               False\n",
       "monitortype        False\n",
       "monitorport        False\n",
       "monitortag          True\n",
       "monitortext         True\n",
       "monitorfile        False\n",
       "monitorprogram     False\n",
       "monitorjob         False\n",
       "monitoroperator     True\n",
       "monitorerrinfo     False\n",
       "monitorvar1         True\n",
       "dtype: bool"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.dtypes\n",
    "df1.dtypes.eq(object)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZEAAAD4CAYAAAAtrdtxAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8QZhcZAAAZMUlEQVR4nO3de5ScdZ3n8fc3FwkgCLngYkJIWDPhlnCxgaxRh4ExBlgkXlhRFrKAk12FXT3s7BjcmQXG0YNz1DgcGUdmZQiuLALuYMbVkwkQEI5o6CgGIggRs9CGA0yCEAcQw3z3j/p1LEJ1d/WTrq4q+v06p07V830u9a2nu/PJc63ITCRJqmJcuxuQJHUvQ0SSVJkhIkmqzBCRJFVmiEiSKpvQ7gZG29SpU3PWrFntbkOSusb69ev/KTOnNRo35kJk1qxZ9Pb2trsNSeoaEfH/Bhrn7ixJUmWGiCSpMkNEklTZmDsmIqk7/fa3v6Wvr48XX3yx3a28Zk2aNIkZM2YwceLEpucxRCR1hb6+PvbZZx9mzZpFRLS7ndeczGTr1q309fUxe/bspudzd5akrvDiiy8yZcoUA6RFIoIpU6YMe0vPEJHUNQyQ1qqyfg0RSVJlhoik7hQxso82eutb3wrA5s2buf7664c9/5YtW3j/+98/6DTXXnstF110UaX+BtPSEImIzRFxf0TcFxG9pTY5ItZExCPlef9Sj4i4MiI2RcSGiDi2bjlLy/SPRMTSuvpbyvI3lXnd1h1pI/2H2gV/0NJo+/73vw9UC5EdO3bwpje9iZtvvrkVrQ1pNLZE/iAzj87MnjK8HLgtM+cAt5VhgFOAOeWxDPgy1EIHuBQ4ATgeuLQ/eMo0y+rmW9z6jyNprNq8eTOHHnooH/7whznyyCM5++yzufXWW1m4cCFz5sxh3bp1bNu2jSVLljB//nwWLFjAhg0bALjssss4//zzOfHEEznkkEO48sordy739a9/PQDLly/nrrvu4uijj2bFihW8+OKLnHfeecybN49jjjmGtWvXArWtijPPPJPTTz+dRYsWsXnzZo488kiAAecBePzxx1m8eDFz587l8ssvH5F10o5TfM8ATiyvVwJ3AJ8o9euy9n29P4iI/SLiwDLtmszcBhARa4DFEXEHsG9m3lPq1wFLgO+O2ieRNOZs2rSJm266iauvvprjjjuO66+/nrvvvptVq1bxmc98hoMOOohjjjmGW265hdtvv51zzz2X++67D4CHHnqItWvXsn37dubOnctHPvKRV1yTccUVV/C5z32Ob3/72wB8/vOfB+D+++/noYceYtGiRTz88MMA3HPPPWzYsIHJkyezefPmncu46qqrBpxn3bp1PPDAA+y1114cd9xxnHbaafT09LA7Wr0lksA/RsT6iFhWam/MzCcAyvMBpT4deLxu3r5SG6ze16AuSS0ze/Zs5s2bx7hx4zjiiCM4+eSTiQjmzZvH5s2bufvuuznnnHMAOOmkk9i6dSvPPvssAKeddhp77LEHU6dO5YADDuDJJ58c9L3ql3XooYdy8MEH7wyEd77znUyePHnY80yZMoU999yT9773vdx99927vT5avSWyMDO3RMQBwJqIeGiQaRvtCM8K9VcvuBZgywBmzpw5eMeSNIg99thj5+tx48btHB43bhw7duxgwoRX/7Paf7i2ft7x48ezY8eOQd+rtmOmsb333nvY8+x62HgkDiO3dEskM7eU56eAv6d2TOPJspuK8vxUmbwPOKhu9hnAliHqMxrUG/VxdWb2ZGbPtGkNb4kvSSPiHe94B1//+tcBuOOOO5g6dSr77rtvU/Pus88+bN++veGyHn74YR577DHmzp3b9PvvOs+aNWvYtm0bL7zwArfccgsLFy4c9ufbVctCJCL2joh9+l8Di4AHgFVA/xlWS4FvldergHPLWVoLgGfL7q7VwKKI2L8cUF8ErC7jtkfEgnJW1rl1y5L0Wpc5so8Rctlll9Hb28v8+fNZvnw5K1eubHre+fPnM2HCBI466ihWrFjBRz/6UV5++WXmzZvHBz7wAa699tpXbM3U69+qGGyet73tbZxzzjkcffTRvO9979vt4yEAMdimz24tOOIQalsfUNttdn1mfjoipgA3AjOBx4AzM3NbCYIvUTvD6nngvMzsPy34fOCTZVmfzsy/K/Ue4FpgT2oH1P9zDvGBenp60i+lGoZ2nW7bot9Lda8HH3yQww47rN1tdKT169dz8cUXc+edd+72shqt54hYX3eG7Su07JhIZj4KHNWgvhU4uUE9gQsHWNY1wDUN6r3AkbvdrCR1qd7eXj70oQ9xxRVXtOX9vYuvJHWxnp6enWdftYO3PZHUNVq1+101VdavISKpK0yaNImtW7caJC3S/30ikyZNGtZ87s6S1BVmzJhBX18fTz/9dLtbec3q/2bD4TBEJHWFiRMnDusb9zQ63J0lSarMEJEkVWaISJIqM0QkSZUZIpKkygwRSVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqM0QkSZUZIpKkygwRSVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqM0QkSZUZIpKkygwRSVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqa3mIRMT4iPhxRHy7DM+OiB9GxCMR8Y2IeF2p71GGN5Xxs+qWcUmp/ywi3lVXX1xqmyJieas/iyTplUZjS+RjwIN1w58FVmTmHOAZ4IJSvwB4JjPfDKwo0xERhwNnAUcAi4G/LsE0HrgKOAU4HPhgmVaSNEpaGiIRMQM4DfifZTiAk4CbyyQrgSXl9RllmDL+5DL9GcANmfmbzPwFsAk4vjw2ZeajmfkScEOZVpI0Slq9JfJF4E+AfynDU4BfZeaOMtwHTC+vpwOPA5Txz5bpd9Z3mWeg+qtExLKI6I2I3qeffnp3P5MkqWhZiETEvwWeysz19eUGk+YQ44Zbf3Ux8+rM7MnMnmnTpg3StSRpOCa0cNkLgXdHxKnAJGBfalsm+0XEhLK1MQPYUqbvAw4C+iJiAvAGYFtdvV/9PAPVJUmjoGVbIpl5SWbOyMxZ1A6M356ZZwNrgfeXyZYC3yqvV5VhyvjbMzNL/axy9tZsYA6wDrgXmFPO9npdeY9Vrfo8kqRXa+WWyEA+AdwQEX8B/Bj4aql/FfhaRGyitgVyFkBmboyIG4GfAjuACzPzZYCIuAhYDYwHrsnMjaP6SSRpjIvaf/bHjp6enuzt7W13G90jGh16GgVj7PdS6mQRsT4zexqN84p1SVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqM0QkSZUZIpKkygwRSVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqM0QkSZUZIpKkygwRSVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqM0QkSZUZIpKkypoKkYg4stWNSJK6T7NbIn8TEesi4qMRsV9LO5IkdY2mQiQz3wacDRwE9EbE9RHxzpZ2JknqeE0fE8nMR4A/BT4B/D5wZUQ8FBHvbVVzkqTO1uwxkfkRsQJ4EDgJOD0zDyuvV7SwP0lSB5vQ5HRfAv4W+GRmvtBfzMwtEfGnLelMktTxmg2RU4EXMvNlgIgYB0zKzOcz82st606S1NGaPSZyK7Bn3fBepSZJGsOaDZFJmfnr/oHyeq/BZoiISeW04J9ExMaIuLzUZ0fEDyPikYj4RkS8rtT3KMObyvhZdcu6pNR/FhHvqqsvLrVNEbG8+Y8tSRoJzYbIP0fEsf0DEfEW4IVBpgf4DXBSZh4FHA0sjogFwGeBFZk5B3gGuKBMfwHwTGa+mdrB+s+W9zocOAs4AlgM/HVEjI+I8cBVwCnA4cAHy7SSpFHSbIh8HLgpIu6KiLuAbwAXDTZD1vRvvUwsj6R2RtfNpb4SWFJen1GGKeNPjogo9Rsy8zeZ+QtgE3B8eWzKzEcz8yXghjKtJGmUNHVgPTPvjYhDgblAAA9l5m+Hmq9sLawH3kxtq+HnwK8yc0eZpA+YXl5PBx4v77cjIp4FppT6D+oWWz/P47vUTxigj2XAMoCZM2cO1bYkqUnDuQHjccB84Bhqu47OHWqGzHw5M48GZlDbcjis0WTlOQYYN9x6oz6uzsyezOyZNm3aUG1LkprU1JZIRHwN+NfAfcDLpZzAdc3Mn5m/iog7gAXAfhExoWyNzAC2lMn6qN1WpS8iJgBvALbV1fvVzzNQXZI0Cpq9TqQHODwzG/5Pv5GImAb8tgTInsAfUjtYvhZ4P7VjGEuBb5VZVpXhe8r42zMzI2IVcH1EfAF4EzAHWEdtS2RORMwGfknt4PuHmu1PkrT7mg2RB4B/BTwxjGUfCKwsx0XGATdm5rcj4qfADRHxF8CPga+W6b8KfC0iNlHbAjkLIDM3RsSNwE+BHcCFdRc9XgSsBsYD12TmxmH0J0naTdHMxkVErKV2mu46aqfuApCZ725da63R09OTvb297W6je0SjQ0+joPmNXkktFhHrM7On0bhmt0QuG7l2JEmvFc2e4ntnRBwMzMnMWyNiL2q7kCRJY1izt4L/I2oXAH6llKYDt7SqKUlSd2j2OpELgYXAc7DzC6oOaFVTkqTu0GyI/KbcWgSAch2HRz4laYxrNkTujIhPAnuW71a/CfiH1rUlSeoGzYbIcuBp4H7gPwLfofZ965KkMazZs7P+hdrX4/5ta9uRJHWTZu+d9QsaHAPJzENGvCNJUtcYzr2z+k0CzgQmj3w7kqRu0tQxkczcWvf4ZWZ+kdqXS0mSxrBmd2cdWzc4jtqWyT4t6UiS1DWa3Z31+brXO4DNwL8b8W4kSV2l2bOz/qDVjUiSuk+zu7MuHmx8Zn5hZNqRJHWT4ZyddRy1bx8EOB34HvB4K5qSJHWHZkNkKnBsZm4HiIjLgJsy88OtakyS1Pmave3JTOCluuGXgFkj3o0kqas0uyXyNWBdRPw9tSvX3wNc17KuJEldodmzsz4dEd8F3l5K52Xmj1vXliSpGzS7OwtgL+C5zPwroC8iZreoJ0lSl2j263EvBT4BXFJKE4H/1aqmJEndodktkfcA7wb+GSAzt+BtTyRpzGs2RF7KzKTcDj4i9m5dS5KkbtFsiNwYEV8B9ouIPwJuxS+okqQxr9mzsz5Xvlv9OWAu8D8yc01LO5MkdbwhQyQixgOrM/MPAYNDkrTTkLuzMvNl4PmIeMMo9CNJ6iLNXrH+InB/RKyhnKEFkJn/pSVdSZK6QrMh8n/LQ5KknQYNkYiYmZmPZebK0WpIktQ9hjomckv/i4j45nAWHBEHRcTaiHgwIjZGxMdKfXJErImIR8rz/qUeEXFlRGyKiA313+seEUvL9I9ExNK6+lsi4v4yz5UREcPpUZK0e4YKkfp/lA8Z5rJ3AP81Mw8DFgAXRsThwHLgtsycA9xWhgFOAeaUxzLgy1ALHeBS4ATgeODS/uAp0yyrm2/xMHuUJO2GoUIkB3g9pMx8IjN/VF5vBx4EpgNnAP27x1YCS8rrM4DrsuYH1C5sPBB4F7AmM7dl5jPUTjNeXMbtm5n3lKvpr6tbliRpFAx1YP2oiHiO2hbJnuU1ZTgzc99m3iQiZgHHAD8E3piZT1BbwBMRcUCZbDqv/LrdvlIbrN7XoC5JGiWDhkhmjt/dN4iI1wPfBD6emc8Nctii0YisUG/UwzJqu72YOXPmUC1Lkpo0nO8TGbaImEgtQL6emf+nlJ8su6Ioz0+Veh9wUN3sM4AtQ9RnNKi/SmZenZk9mdkzbdq03ftQkqSdWhYi5UyprwIPZuYX6katAvrPsFoKfKuufm45S2sB8GzZ7bUaWBQR+5cD6ouo3YblCWB7RCwo73Vu3bIkSaOg2YsNq1gInEPtSvf7Su2TwBXU7gp8AfAYcGYZ9x3gVGAT8DxwHkBmbouITwH3lun+PDO3ldcfAa4F9gS+Wx6SpFEStRObxo6enp7s7e1tdxvdo12X3oyx30upk0XE+szsaTSupcdEJEmvbYaIJKkyQ0SSVJkhIkmqzBCRJFVmiEiSKjNEJEmVGSKSpMoMEUlSZYaIJKkyQ0SSVJkhIkmqzBCRJFVmiEiSKjNEJEmVGSKSpMoMEUlSZYaIJKkyQ0SSVJkhIkmqzBCRJFVmiEiSKjNEJEmVGSKSpMoMEUlSZYaIJKkyQ0SSVJkhIkmqzBCRJFVmiEiSKjNEJEmVGSKSpMpaFiIRcU1EPBURD9TVJkfEmoh4pDzvX+oREVdGxKaI2BARx9bNs7RM/0hELK2rvyUi7i/zXBkR0arPIklqrJVbItcCi3epLQduy8w5wG1lGOAUYE55LAO+DLXQAS4FTgCOBy7tD54yzbK6+XZ9L0lSi7UsRDLze8C2XcpnACvL65XAkrr6dVnzA2C/iDgQeBewJjO3ZeYzwBpgcRm3b2bek5kJXFe3LEnSKBntYyJvzMwnAMrzAaU+HXi8brq+Uhus3teg3lBELIuI3ojoffrpp3f7Q0iSajrlwHqj4xlZod5QZl6dmT2Z2TNt2rSKLUqSdjXaIfJk2RVFeX6q1PuAg+qmmwFsGaI+o0FdkjSKRjtEVgH9Z1gtBb5VVz+3nKW1AHi27O5aDSyKiP3LAfVFwOoybntELChnZZ1btyxJ6lwR7Xm0yIRWLTgi/jdwIjA1IvqonWV1BXBjRFwAPAacWSb/DnAqsAl4HjgPIDO3RcSngHvLdH+emf0H6z9C7QywPYHvlockaRRF7eSmsaOnpyd7e3vb3Ub3aNflN2Ps91JjSBf+TUXE+szsaTSuUw6sS5K6kCEiSarMEJEkVWaISJIqM0QkSZUZIpKkygwRSVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqM0QkSZUZIpKkygwRSVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqM0QkSZUZIpKkygwRSVJlhogkqTJDRJJUmSEiSarMEJEkVWaISJIqm9DuBrpKRHveN7M97ytJQ3BLRJJUmSEiSarMEJEkVdb1IRIRiyPiZxGxKSKWt7sfSRpLujpEImI8cBVwCnA48MGIOLy9XUnS2NHVIQIcD2zKzEcz8yXgBuCMNvckSWNGt5/iOx14vG64Dzhh14kiYhmwrAz+OiJ+NsDypgL/NKIdjoRXnlrcmT2+0u732PrTqcfGemw9exwZre9x9/6mDh5oRLeHSKO18qqLKjLzauDqIRcW0ZuZPSPRWKvY48iwx5FhjyOjG3ocSLfvzuoDDqobngFsaVMvkjTmdHuI3AvMiYjZEfE64CxgVZt7kqQxo6t3Z2Xmjoi4CFgNjAeuycyNu7HIIXd5dQB7HBn2ODLscWR0Q48NRXpfJklSRd2+O0uS1EaGiCSpstd0iETEQRGxNiIejIiNEfGxUj8qIu6JiPsj4h8iYt9SPz4i7iuPn0TEe+qW1ZLbq4xwj5vL9PdFRG+7eqybb2ZE/Doi/riu1hHrcYgeO2I9RsSsiHih7uf9N3XLekuZflNEXBkxMhfWjHCPd5Sfdf+4A9rRYxk3v4zbWMZPKvWOWI9D9NiS9ThiMvM1+wAOBI4tr/cBHqZ2e5R7gd8v9fOBT5XXewET6uZ9itrJB+OBnwOHAK8DfgIc3kk9luHNwNR2r8e6+b4J3AT8cRnumPU4UI+dtB6BWcADAyxrHfBvqF0r9V3glA7s8Q6gpwPW4wRgA3BUGZ4CjO+w9ThYjy1ZjyP1eE1viWTmE5n5o/J6O/Agtavc5wLfK5OtAd5Xpnk+M3eU+iR+d+Fiy26vMoI9tsxwewSIiCXAo0D92XIdsx4H6bFlqvTYSEQcCOybmfdk7V+Z64AlndRjK1XocRGwITN/UubZmpkvd9h6bNjjSPTSaq/pEKkXEbOAY4AfAg8A7y6jzqTugsWIOCEiNgL3A/+p/IPd6PYq0zusR6gFyj9GxPqo3eplxDXTY0TsDXwCuHyX2TtmPQ7SI3TIeixmR8SPI+LOiHh7qU2ntu76tfX3cYAe+/1d2QXzZyO1q6hCj78HZESsjogfRcSflHonrceBeuzX0vW4O8ZEiETE66nttvh4Zj5HbTPywohYT21T86X+aTPzh5l5BHAccEnZL9nU7VXa3CPAwsw8ltpdjS+MiHe0qcfLgRWZ+etdF9Fgse1ajwP1CJ2zHp8AZmbmMcDFwPVlH3onrceBegQ4OzPnAW8vj3Pa1OME4G3A2eX5PRFxMp21HgfqEVq8Hndbu/entfoBTKR2MeLFA4z/PWDdAOPWAj3U9pmurqtfAlzSST02qF9G3X7+0ewRuIvacYXNwK+AbcBFnbQeB+qxk9Zjg3F3lN/HA4GH6uofBL7SST02qP8H4Ett+lmfBVxbN+7PgP/WSetxoB5bvR5H5HO2u4GWfrja/zSuA764S/2A8jyujD+/DM/mdwepD6Z2H66p1P6X8GgZ339A+IgO63FvYJ9S3xv4PrC4HT3uMs3Of4Q7aT0O0mPHrEdgGr87uHoI8Etgchm+F1jA7w4In9pJPZaf9dRSnwjcTG3Xazt63B/4EeWkFOBW4LQOW48Ne2zlehypR9sbaOmHq20WJrWzHu4rj1OBj1E7W+Jh4Ap+d+X+OdQOst5XfqBL6pZ1apn+58B/77Qeyx/wT8pjYzt73GXey3jlmU8dsR4H6rGT1iO1g64bSy8/Ak6vW1YPtf3rPwe+1OhztbNHagG8vixnI/BXlLBpx88a+PeljweAv+y09ThQj61cjyP18LYnkqTKxsSBdUlSaxgikqTKDBFJUmWGiCSpMkNEklSZISJJqswQkSRV9v8BBUG2CgozLgcAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df1.plot(x='monitorerrinfo', y='monitorjob',color='red',kind='hist')\n",
    "plt.show()"
   ]
  },
  {
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitortext</th>\n",
       "      <th>monitorfile</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>monitoroperator</th>\n",
       "      <th>monitorerrinfo</th>\n",
       "      <th>monitorvar1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>8076509</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YLOAD</td>\n",
       "      <td>Percentage of Max Y-load: 48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>8076511</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>8076512</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>9.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>8076513</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>2.32915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>8076516</td>\n",
       "      <td>2019-12-05 01:00:01</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.3674</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            monitorid                date  monitortype  monitorport  \\\n",
       "Unnamed: 0                                                            \n",
       "0             8076509 2019-12-05 01:00:00         4096          271   \n",
       "1             8076511 2019-12-05 01:00:00         4096          271   \n",
       "2             8076512 2019-12-05 01:00:00         4096          271   \n",
       "3             8076513 2019-12-05 01:00:00         4096          271   \n",
       "4             8076516 2019-12-05 01:00:01         4096          271   \n",
       "\n",
       "           monitortag                   monitortext  monitorfile  \\\n",
       "Unnamed: 0                                                         \n",
       "0               YLOAD  Percentage of Max Y-load: 48          NaN   \n",
       "1                XPOS           Absolute X-position          NaN   \n",
       "2                YPOS           Absolute Y-position          NaN   \n",
       "3                ZPOS           Absolute Y-position          NaN   \n",
       "4                XPOS           Absolute X-position          NaN   \n",
       "\n",
       "            monitorprogram  monitorjob monitoroperator  monitorerrinfo  \\\n",
       "Unnamed: 0                                                               \n",
       "0                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "1                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "2                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "3                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "4                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "\n",
       "           monitorvar1  \n",
       "Unnamed: 0              \n",
       "0                   48  \n",
       "1               35.423  \n",
       "2                 9.29  \n",
       "3              2.32915  \n",
       "4              35.3674  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>monitorerrinfo</th>\n",
       "      <th>monitorvar1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>8076509</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YLOAD</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>8076511</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>8076512</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YPOS</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>9.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>8076513</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>2.32915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>8076516</td>\n",
       "      <td>2019-12-05 01:00:01</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.3674</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>61837</td>\n",
       "      <td>8297783</td>\n",
       "      <td>2019-12-05 11:59:34</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61838</td>\n",
       "      <td>8297790</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>376.1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61839</td>\n",
       "      <td>8297791</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61840</td>\n",
       "      <td>8297813</td>\n",
       "      <td>2019-12-05 11:59:41</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61841</td>\n",
       "      <td>8297820</td>\n",
       "      <td>2019-12-05 11:59:42</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61842 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            monitorid                date  monitortype  monitorport  \\\n",
       "Unnamed: 0                                                            \n",
       "0             8076509 2019-12-05 01:00:00         4096          271   \n",
       "1             8076511 2019-12-05 01:00:00         4096          271   \n",
       "2             8076512 2019-12-05 01:00:00         4096          271   \n",
       "3             8076513 2019-12-05 01:00:00         4096          271   \n",
       "4             8076516 2019-12-05 01:00:01         4096          271   \n",
       "...               ...                 ...          ...          ...   \n",
       "61837         8297783 2019-12-05 11:59:34         4096          271   \n",
       "61838         8297790 2019-12-05 11:59:37         4096          271   \n",
       "61839         8297791 2019-12-05 11:59:37         4096          271   \n",
       "61840         8297813 2019-12-05 11:59:41         4096          271   \n",
       "61841         8297820 2019-12-05 11:59:42         4096          271   \n",
       "\n",
       "           monitortag  monitorprogram  monitorjob  monitorerrinfo monitorvar1  \n",
       "Unnamed: 0                                                                     \n",
       "0               YLOAD          2940.0      2940.0    1.574712e+09          48  \n",
       "1                XPOS          2940.0      2940.0    1.574712e+09      35.423  \n",
       "2                YPOS          2940.0      2940.0    1.574712e+09        9.29  \n",
       "3                ZPOS          2940.0      2940.0    1.574712e+09     2.32915  \n",
       "4                XPOS          2940.0      2940.0    1.574712e+09     35.3674  \n",
       "...               ...             ...         ...             ...         ...  \n",
       "61837            TEMP          9271.0      2940.0    1.574712e+09          26  \n",
       "61838            ZPOS          9271.0      2940.0    1.574712e+09    376.1973  \n",
       "61839            TEMP          9271.0      2940.0    1.574712e+09          25  \n",
       "61840            TEMP          9271.0      2940.0    1.574712e+09          26  \n",
       "61841            TEMP             NaN         NaN             NaN          25  \n",
       "\n",
       "[61842 rows x 9 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.drop(['monitorfile','monitortext','monitoroperator'],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "monitorid                   int64\n",
       "date               datetime64[ns]\n",
       "monitortype                 int64\n",
       "monitorport                 int64\n",
       "monitortag                 object\n",
       "monitortext                object\n",
       "monitorfile               float64\n",
       "monitorprogram            float64\n",
       "monitorjob                float64\n",
       "monitoroperator            object\n",
       "monitorerrinfo            float64\n",
       "monitorvar1                object\n",
       "dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>monitorid</th>\n",
       "      <th>date</th>\n",
       "      <th>monitortype</th>\n",
       "      <th>monitorport</th>\n",
       "      <th>monitortag</th>\n",
       "      <th>monitortext</th>\n",
       "      <th>monitorfile</th>\n",
       "      <th>monitorprogram</th>\n",
       "      <th>monitorjob</th>\n",
       "      <th>monitoroperator</th>\n",
       "      <th>monitorerrinfo</th>\n",
       "      <th>monitorvar1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>8076509</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YLOAD</td>\n",
       "      <td>Percentage of Max Y-load: 48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>8076511</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>8076512</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>YPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>9.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>8076513</td>\n",
       "      <td>2019-12-05 01:00:00</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>2.32915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>8076516</td>\n",
       "      <td>2019-12-05 01:00:01</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>XPOS</td>\n",
       "      <td>Absolute X-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>35.3674</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>61837</td>\n",
       "      <td>8297783</td>\n",
       "      <td>2019-12-05 11:59:34</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61838</td>\n",
       "      <td>8297790</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>ZPOS</td>\n",
       "      <td>Absolute Y-position</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>376.1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61839</td>\n",
       "      <td>8297791</td>\n",
       "      <td>2019-12-05 11:59:37</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61840</td>\n",
       "      <td>8297813</td>\n",
       "      <td>2019-12-05 11:59:41</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9271.0</td>\n",
       "      <td>2940.0</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1.574712e+09</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61841</td>\n",
       "      <td>8297820</td>\n",
       "      <td>2019-12-05 11:59:42</td>\n",
       "      <td>4096</td>\n",
       "      <td>271</td>\n",
       "      <td>TEMP</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61842 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            monitorid                date  monitortype  monitorport  \\\n",
       "Unnamed: 0                                                            \n",
       "0             8076509 2019-12-05 01:00:00         4096          271   \n",
       "1             8076511 2019-12-05 01:00:00         4096          271   \n",
       "2             8076512 2019-12-05 01:00:00         4096          271   \n",
       "3             8076513 2019-12-05 01:00:00         4096          271   \n",
       "4             8076516 2019-12-05 01:00:01         4096          271   \n",
       "...               ...                 ...          ...          ...   \n",
       "61837         8297783 2019-12-05 11:59:34         4096          271   \n",
       "61838         8297790 2019-12-05 11:59:37         4096          271   \n",
       "61839         8297791 2019-12-05 11:59:37         4096          271   \n",
       "61840         8297813 2019-12-05 11:59:41         4096          271   \n",
       "61841         8297820 2019-12-05 11:59:42         4096          271   \n",
       "\n",
       "           monitortag                   monitortext  monitorfile  \\\n",
       "Unnamed: 0                                                         \n",
       "0               YLOAD  Percentage of Max Y-load: 48          NaN   \n",
       "1                XPOS           Absolute X-position          NaN   \n",
       "2                YPOS           Absolute Y-position          NaN   \n",
       "3                ZPOS           Absolute Y-position          NaN   \n",
       "4                XPOS           Absolute X-position          NaN   \n",
       "...               ...                           ...          ...   \n",
       "61837            TEMP                            26          NaN   \n",
       "61838            ZPOS           Absolute Y-position          NaN   \n",
       "61839            TEMP                            25          NaN   \n",
       "61840            TEMP                            26          NaN   \n",
       "61841            TEMP                            25          NaN   \n",
       "\n",
       "            monitorprogram  monitorjob monitoroperator  monitorerrinfo  \\\n",
       "Unnamed: 0                                                               \n",
       "0                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "1                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "2                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "3                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "4                   2940.0      2940.0             Kim    1.574712e+09   \n",
       "...                    ...         ...             ...             ...   \n",
       "61837               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61838               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61839               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61840               9271.0      2940.0             Kim    1.574712e+09   \n",
       "61841                  NaN         NaN             NaN             NaN   \n",
       "\n",
       "           monitorvar1  \n",
       "Unnamed: 0              \n",
       "0                   48  \n",
       "1               35.423  \n",
       "2                 9.29  \n",
       "3              2.32915  \n",
       "4              35.3674  \n",
       "...                ...  \n",
       "61837               26  \n",
       "61838         376.1973  \n",
       "61839               25  \n",
       "61840               26  \n",
       "61841               25  \n",
       "\n",
       "[61842 rows x 12 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.drop(['monitortag'],axis=1)\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "monitorid                   int64\n",
       "date               datetime64[ns]\n",
       "monitortype                 int64\n",
       "monitorport                 int64\n",
       "monitortag                 object\n",
       "monitortext                object\n",
       "monitorfile               float64\n",
       "monitorprogram            float64\n",
       "monitorjob                float64\n",
       "monitoroperator            object\n",
       "monitorerrinfo            float64\n",
       "monitorvar1                object\n",
       "dtype: object"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAaEAAAEGCAYAAADMsSqUAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8QZhcZAAAgAElEQVR4nO3de5hU1Znv8e9Lc8cbKGMiopAJGo0YY/ohxFscMagzKk7Go3AwAQePRx1jRp3j5cyIiTnneUYfEyeaQOJIEhM5KHGMAolBoskoTgTxBggaURRQYlpAFC/cfM8fe1V6d3ddu2vXrl31+zxPPbtq1dprr66u3W+vvdd+t7k7IiIiaeiVdgdERKR5KQiJiEhqFIRERCQ1CkIiIpIaBSEREUlN77Q7UO/2228/HzFiRNrdEBHJlKeeeuotdx9aqp6CUAkjRoxg2bJlaXdDRCRTzOy1curpcJyIiKRGQUhERFKjICQiIqlJNAiZ2eVm9ryZrTSzOWbW38xmmdlzZrbczO41sz1C3X5mdo+ZrTGzJWY2ItbOtaH8RTM7JVZ+aihbY2bXxMpHhjZeCm32LbUNERGpvcSCkJkNAy4DWt39CKAFmAhc7u6fcfcjgXXApWGVacAWd/8kcAtwY2jn8LDep4FTgRlm1mJmLcD3gdOAw4FJoS5h3VvcfRSwJbRdcBsiIpKOpA/H9QYGmFlvYCDwhru/A2BmBgwAchlUJwB3huf3AuNCnQnA3e6+3d3XAmuAMeGxxt1fcfcdwN3AhLDOSaENQptnldiGiEh2HX44mEXLjEksCLn768DNRKOdjcBWd38IwMx+DPwR+BRwW1hlGLA+rLsL2ArsGy8PNoSyQuX7Am+HNuLlxbbRgZldaGbLzGxZW1tbNz8BEZEaMIPVq6Pnq1dHrzMkycNxg4lGHiOBA4BBZnYegLufH8pWA+fmVsnTjFexvNg2Oha43+7ure7eOnRoyWutRETSUWjkk6ERUZKH404G1rp7m7vvBO4Djsm96e67gXuAvwtFG4DhAOHw3d7A5nh5cCDwRpHyt4B9Qhvx8mLbEBHJntwIqNzyOpRkEFoHjDWzgeG8yzhgtZl9Ev58TugM4IVQfx4wJTw/G3jEozvuzQMmhpltI4FRwFLgSWBUmAnXl2jywrywzm9DG4Q2HyixDRERSUFiaXvcfYmZ3Qs8DewCngFuBx4xs72IDo09B1wcVpkF/MzM1hCNTiaGdp43s7nAqtDOP4RRFGZ2KbCQaObdj9z9+dDW1cDdZvZ/wnZnFduGiIikwzQQKK61tdWVO05E6tLq1fnP/6xaBYcdVvv+xJjZU+7eWqqeMiaIiGTVnDmVldchjYRK0EhIROpWSwt89FHX8l69YPfu2vcnRiMhEZFGly8AFSuvQwpCUn/M2h/NbPZsmDAhWorkVPt7Ed/fPvGJ9mWN6HBcCTocV2P5Ak8zfkeHD4cNGzq+Xrcuvf5Ifej8vSimnP2m1D96Pdj3dDhOsqfQDtFsI6LZs7v+oVm/XiOiZpfve9ET5exXNRgRKQiJ1Ju5cysrl+aQxu9/7drEN6EgJFJvzjmnsnJpDpX8/vv1q842R46sTjtFKAhJ/Sh0/LnZzglNnhwd+48bPjwql+ZV6HuRz4cflm6vnP3qlVdK1+khBSGpL513jGYLQDnr1sFdd8GZZ0ZLTUoQyP+9cG8f+fTrV9k+07lubuQzcmTN9j3NjitBs+NqTLPjRBqCZsdJ9hx4YGXlIpJ5CkJSP15/vbJyEck8BSGpH337VlaeowwLIpmlICT145BDKiuHroFHgUga3fTpcOih0TInw/+IaWJCCZqYUEPFdqB839NK64tkXd++sHNnx9c7dnStVwfff01MEBFpJNOndwxAkD8AQaZGRApCIiJZMGNG2j1IhIKQZJcyLEgz2b49mXb79YtGTv36weDB0fPBg5PZVh69a7YlkSS4dzz0oAAkjWrvvWHbtuq2Gd93duxoP7z39tvRezXYnzQSqjdtbfDkk9FS2uk2BtLs/vIvq9teOUlOazAiUhCqJ3PmwMEHw5e+FC3nzEm7R/WjUBp7TdGWZvG//ld12ys0qSHu7beru808FITqRVsbTJsGH3wAW7dGy2nTmmtE1NJS+L18aex1EzxpJqefXn7datxVtUYUhOrFq692zQzQp09U3ix27y78nm5jIM1u7Njy65aTb/GMM7rflypSEKoXI0Z0HR7v3BmVi4gsXVp+3XLyLZZzk7wJE8rfZjcpCNWLoUNh1iwYMAD22itazpoVlUt+F11UWbmItMt3k7zO7r8/8W4obU8JNU/b09YWHYIbMaL5AlCxY9Tz53c9Jq60PdJMBgwo746pOeXuA7NnRxN/zjkHfv5z+M1v4OSTexyAyk3boyBUgnLH1VCxoDJtGtxxR/n19b2WRnP88bB4cfn1U94HlDtOGstZZ6XdA5F0FZu4k4TVq+HOO6NlghSEJBvyTU8t9F9hJf8timRFJdfsDBjQs2197Wtw+OEwdWq0/NrXetZeEQpCkl3HHgvjx3csGz8+KhdpNO+9V37dDz7o/nZWr4bvfa9j2fe+l9iISEFIsm3hwuKvs2zmTDjhhGgpktRt7gcNis6vDhoE48bB6NH561UyRbwCSmAq2ZYvbU8jTEoYMgS2bImeP/YY/Mu/wKZN6fZJ0tXaCkuWVLfN+P7z/vvwyCOF644ZU91tBxoJSXY1atqemTPbA1DO5s0aETW7L3+5uu0NGlR+3UsvhcMOq+72AwUhkXpTKHGtEto2t1tvrW57779fuk5LC6xaBbfdVt1txygIidSbSZMqK5fm0Hl03FMDB5au88UvJjYCykk0CJnZ5Wb2vJmtNLM5ZtbfzGab2Yuh7Edm1ifUPdHMtprZs+ExPdbOqWGdNWZ2Tax8pJktMbOXzOweM+sbyvuF12vC+yNi61wbyl80s1OS/PklYUOGVFaeFRdf3PVnGDIkKpfmVUm2hHKUM9vu4Yeru808EgtCZjYMuAxodfcjgBZgIjAb+BQwGhgAXBBb7TF3Pyo8bgjttADfB04DDgcmmdnhof6NwC3uPgrYAkwL5dOALe7+SeCWUI+w3kTg08CpwIzQvtS7fNNDN2/OX7dQeZZs2gQzZkRXyc+YoUkJAr0S+HPt3j4iGjgQTjopyuZ/0kk1m+CT9OG43sAAM+sNDATecPdfeQAsBUrlHB8DrHH3V9x9B3A3MMHMDDgJuDfUuxPIXVY/IbwmvD8u1J8A3O3u2919LbAmtC/1LqHpoXXt4ovh0Uc1ApLIHnsk0+5770UB5733opHP9u01GQHlJBaE3P114GZgHbAR2OruD+XeD4fhvgL8OrbaF8zsOTN70Mw+HcqGAetjdTaEsn2Bt919V6fyDuuE97eG+oXa6sDMLjSzZWa2rK2ZbipXzxKaHiqSGb0b84qaJA/HDSYaeYwEDgAGmdl5sSozgEfd/bHw+mngYHf/DHAbkEvhmm++rRcp7+467QXut7t7q7u3Dm22TNb1Kt/J0RtvzF+3ULlIljXoIdkkD8edDKx19zZ33wncBxwDYGbXA0OBK3KV3f0dd98Wnv8K6GNm+xGNVuI3vTgQeAN4C9gnHOqLlxNfJ7y/N7C5SFuSRVdd1fVah0GDonKRRlPObLYMSjIIrQPGmtnAcD5mHLDazC4ATgEmuftHucpm9rFQDzMbE/q2CXgSGBVmwvUlmlgwL5xT+i1wdmhiCvBAeD4vvCa8/0ioPw+YGGbPjQRGEZ2Xkqzati0a+Rx1VLTcti3tHokko5LccRmS5DmhJUSTAp4GVoRt3Q78ANgf+H2nqdhnAyvN7DngVmBimL+wC7gUWAisBua6+/NhnauBK8xsDdE5n1mhfBawbyi/Argm9Ol5YC6wiuhc1D+4e43zo0vVXX01PPtstGwks2dHt1eePTvtnkgj69cvyjLSr180CeZjH6vpZBjd1K4E3dSuhrpzk7p86zTCd3r4cNiwoePrdevS64+kb+zYynLHlbMfFNvnzOCjjwq/X7Jp3dROGl2j5o6bPbtjAAJYv14jomZX7Xv69OtX/H33moyIFIRE6s3cuZWVS3Oo9qzPHTtK1/nFL6q7zTwUhETqzTnnVFYuzeHll6vbXt++pev87d9Wd5t56JxQCTonVEM6J9TuoIOiQ3A5OicklR5m1jkhkSrKlzuuUc8JQRRw7roLzjwzWioASRLc20dEffvCRRfB/vtHyx4EoEo0Zh4IaTxLlyaeUr7uTJ4cPUQA+vSBnTur3+727R1f1/jmiRoJSTYod5w0uz33TLsHiVAQkmzINwoqdMy7Ec4JiXQ2alTaPUiEgpBkW+eAowAkjeqtt9LuQSIUhETqldL2SFxSEwV69Yom8/TqBaedBgMGRMsa0RTtEjRFu4Y0Rbud0vZIZzNnwiWXlF+/p1O0y22jYNOaoi2NrlGnaCttj+Rz8cUwZEj12ivnduE1GBEpCInUG6XtkUI2b65eW+WMcn73u+ptrwAFIZF6o7Q9ks/UqdVtr5wjBieeWN1t5qEgJNl1xRWVlWfF5MnROaC44cN14Wqzq/bh2HImOjz4YHW3mYeCkGTXt79dWXmWKG2PdLZrV/XbdG8fEZnBqadC//7RskYTfJS2R7Jh5syu9zYpNjGhEWbIKW2PxO2xRzK3r69RjrhCNBKSbJgzJ+0eiKTrb/4m7R4kQkFIsmHSpLR7IJKuDz5IuweJUBCSbMh3m2HljpNm0qCzIxWEJNuUO06axYsvpt2DRGhigmSfAo80g1tvTbsHidBIKCk33QSf/Wy0lGSZtT8aiRKYStzu3cm0G09gOn06HHpotKwRJTAtoVsJTAcNgvff7/g6iamVjUYJTNspgal0duWV8J3vlF+/pwlM+/btetfVCiiBaVpuuqljAAJ47z2NiJKgBKbSTL785eq2VyqB6Y4dNRkRKQhVW6HrWXSdi5RLCUwln+uvr2575YyU7rmnutvMQ0Go2gpdz6LrXKRcSmAq+Tz5ZHXbK+eIwbnnVnebeSgIVdtVV0XngOIGDYrKpbr22aey8qxQAlPJpwfnZ/Iqla6npSUKVI8/Xt3tdqIglIRt2+DGG+Goo6KlJiUkY8uWysqzRAlMpbNybkJXqc4JTK+7Dg45BEaMiGbj3XADHHccnHJK9bcdFJ0dZ2ZHF1vZ3Z+ueo/qjG7vXUPFDg/cdVfXkUB3ZtOJZNWAAfDhh+XX7+4+8PjjUeDpbPFiOPbYspspd3ZcqYtVcznx+wOtwHOAAUcCS4A8PRVJwNy5Ohwlza2lpTbbeeihwuUVBKFyFR3fuftfuftfAa8BR7t7q7t/DvgssKbqvREpRCflpdnV6lzn+PGVlfdQuQcZP+XuK3Iv3H0lcFQiPRLJJ98oSAlMpZlcdllttnPssV0DzvjxiYyCoPzccavN7A7gLsCB84DVifRIpBLxE6u51yKN6M03a7etGu5H5Y6EzgeeB74O/COwKpSJpM+9/SHSqL773dps5/HHYdGijmUPPZTYVO2ygpC7f+jut7j734bHLe5ecpqGmV1uZs+b2Uozm2Nm/c1stpm9GMp+ZGZ9Ql0zs1vNbI2ZLY/PzDOzKWb2UnhMiZV/zsxWhHVuNYv+JTazIWa2KNRfZGaDS21DMqxRE5guWAAXXBAtRZJKYBrffxYsgEsvzV+v0ISFHioahMxsbliuCH+0OzxKrDsMuAxodfcjgBZgIjAb+BQwGhgAXBBWOQ0YFR4XAjNDO0OA64HPA2OA63NBJdS5MLbeqaH8GuBhdx8FPBxeF9yGZFjnwNMogWj0aDjjDJg1K1oeeWTaPZK0HXZY9dvsvL+ccQY8+2z+uglNTCh1TujrYXl6D9ofYGY7gYHAG+7+53BqZkuBA8PLCcBPPbpw6Qkz28fMPg6cCCxy981hnUXAqWb2O2Avd/99KP8pcBbwYGjrxNDuncDvgKsLbcPdN3bz55M0FUtgmuVDcwsWwMqVHctWrIjKT+/uriiZt2pVdf/JqqStBCcmlJqivdHMWoBZ7v5a50eJdV8HbgbWARuBrZ0CUB/gK8CvQ9EwYH2siQ2hrFj5hjzlAPvnAktY/kWJbYjUj/vvr6xcmsPxx9d+m0cdFV2kunBhYpsoeU7I3XcD75vZ3pU0HA6ZTQBGAgcAg8zsvFiVGcCj7v5YbpV8m+9GedFulbOOmV1oZsvMbFlbW1uJJkWq7KyzKiuX5vDEE7Xf5re+ldgIKKfc2XEfAivMbFY4sX+rmZW61+zJwFp3b3P3ncB9wDEAZnY9MBS4IlZ/AxDP2ngg8EaJ8gPzlAO8GQ7lEZZ/KrGNDtz99nBhbuvQoUNL/JiSmosuqqw8K04/PTonFDd6tA7FNbtqX6xa6pB1jb5z5QahXwLXAY8CT8UexawDxprZwDBrbRzR9UYXAKcAk9w9nsZ1HvDVMINtLNHhu43AQmC8mQ0Oo6vxwMLw3rtmNja0/1XggVhbuVl0UzqV59uGZNHMAvNKCpVnyfLlMH8+TJsWLZcXnQckzeCtt6rfZudAlMJ3ruzbe5tZX+CQ8PLFMLoptc43gXOBXcAzRDPh3iNKA/RuqHafu98QAsn3iGa4vQ+c7+7LQjt/D/zvUP//uvuPQ3kr8BOiWXYPAl9zdzezfYG5wEFEwfC/ufvmYtsoRAlMa6jYidJVq7rODlICU2kmlU5KSHkfKDeBaVlByMxOJJpl9irReZXhwBR3f7Rn3ax/CkI1VGwn+8lPYMqUjmUKQtJMBg6EDz4ov35GglC5aXu+DYx39xdD44cAc4DPdb+LIhUYMybtHoika9gwWNN4eaPLPSfUJxeAANz9D0CfZLokkke+C/WUwFSaSSWjoAwpdyS0zMxmAT8LrydTemKCSPKUwFSaxcCBafcgEeWOhC4mSmB6GVEWhVXA/0yqUyICzJ4NEyZES5GjE0p1Gc8dN3Ei7L13tKyRcicmfN3dv1uqrBFpYkINdWeiQb51GmE0NHw4bNjQ8fW6den1R9J36KHwhz+UX7+c/aDUjLse7EvlTkwodyQ0JU/Z1Ip6JFJtxXLHZdns2R0DEMD69RoRNbsPS964oDLl7Cc1GBGVyqI9yczmAyPNbF7s8VtgU+K9E2lGc+dWVi7NYcSI2m/zwQcT30SpiQn/RZR8dD+iado57wK6hFskCeecA/Pm5S+X5vXFL8KjNb40c9iw6GZ2CeaPKztjQrOq+TmhBQuibMlnndV8ucIqPSfUyBerHnRQdAguR+eE5Jhj4Pe/L79+Nc4J5YwfX3Em7aqcEzKzxWH5rpm9E3u8a2bvVNQjKU03MqtMI18ntG4d3HUXnHlmtFQAkqefrn6bnfeVc8/NPxU8rdt7u/txYbmnu+8Ve+zp7nsl0qNmVexGZpJfo05MyJk8GR54IFqKbN+eTLvu7Y+774Z/+qf89dK4vXecmbWY2QFmdlDukUiPmpVuZCYixQwaVJvtFLqNd0K39y4rCJnZ14A3gUVEt3X4JaB/0atJNzITkWLeey/tHiSi3JHQ14FD3f3T7j46PHTCopp0I7PKNfI5IZG0FDrslvLhuPXA1kR6IO10I7PKdQ44CkDSqBr0cFy5CUxfAX5nZr8E/nx2zN2/k0ivmtnpp2v0UykFHmkGRxwBS5Ykv50tWyor76FyR0LriM4H9QX2jD2kkOnTo1xP06dXtl5bGzz5ZLSU8sQTMDaSmTPhhBMa43bl0nMbNybTbq9e0b7TqxdMnQp/93f56yU0Saqii1XNbE/A3X1bIr2pQ926WLVvX9i5s+PrcqZXzpkTHYrr2xd27IiuF5o0qbJtZ5kSmLYbMqTjf55DhsAmZcpqaldeCd+p4OBTNS9WhegUQQVHaaqawNTMjjCzZ4CVwPNm9pSZfbrs3jST6dM7BiCIAkqpEVFbWxSAPvgAtm6NltOmaURUTKNeJzRzZtdDH5s3a0TU7D75yeq216vsK3Si81EJnSYotxe3A1e4+8HufjBwJfDvifQo6+65p7LynFdfjUZAcX36ROXSXObMqaxcmsO3v126TiUqOWLw3nvpZEyIGeTuv829cPffATWaqpEx555bWXnOiBHRiClu5850MudKugodgm2mQ7PS1UcfVbe9So8YpDxF+xUzu87MRoTHvwBrE+lR1t1wQ9cRTd++UXkxQ4dG54AGDIC99oqWs2ZF5ZJfo14ndPHF0TmguCFDonJpXv37V7e9SoPaIYdUd/tBuUHo74GhwH8A9xHd2mFqIj1qBNu3w3XXRb+0664rP+fTpEnw2mvwm99ES/3nW1qjXie0aRPMmAHHHx8tNSlBXn65+m26t4+IzGDKlMLXI+3aVf3tU/7tvVuBfwZG0H5tkTdD1gTd3ruGih0eWLw4/z1NGnV2nEhno0d3TXJcTHf3g9Wr4fDDu5avWgWHHVZ2M9W+vfds4EfAl4HTw+OMsnsj0lP5jkc36uw4kXwSyljQxWGHwaWXdiy79NKKAlAlys2Y0Obu8xPpgUg5arUDitSrSmZHtrT0bFu33QaXXAJLl8KYMYkFICg/CF1vZncAD9Mxbc99ifRKpLMEby8skgmVHF7bvbvn2zvssESDT065h+POB44CTiU6DHcG0SE5kfQ06uw4kXwuvzztHiSi3JHQZ9x9dOlqIjUWn92Tey3SiPJNFmgA5Y6EnjCzxvwEJPvitycWaVTXXZd2DxJRbhA6DnjWzF40s+VmtsLMdLMbqQ+NmkX7ppvgs5+NliJvvplMu/H9Z+xY6N07WtZIudcJHZyv3N1fq3qP6oyuE6ohZdFuN2gQvP9+x9fbmiZ5veQzfTp861vl169GFu0e7EtVvU7I3V/L9+h270SqoVGvE7rppo4BCKIEkhoRNbd8KcF6opz9pAYjogpyeYtITSiLthTyxS+WV6+S2zQUU4OjQApCIvVGWbQln8cfh0WLyqtbrYzbrSWPpvWYgpBk1403VlaeFVdd1TWJ5KBBUbk0r2uvrW575ZzveeKJ6m4zj0SDkJldbmbPm9lKM5tjZv3N7FIzW2Nmbmb7xeqeaGZbzezZ8Jgee+/UMDNvjZldEysfaWZLzOwlM7vHzPqG8n7h9Zrw/ojYOteG8hfN7JQkf35JWKE/yo3wx3rbtiiYHnVUtNSkBFmbwN1zOgeiz38+Svnz+c/XbIJPYkHIzIYBlwGt7n4E0AJMBB4HTgbyTWx4zN2PCo8bQjstwPeB04DDgUmxa5ZuBG5x91HAFmBaKJ8GbHH3TwK3hHqE9SYCnybK/jAjtC/1bvXqrmWNOjEh56qr4JlnGiOoSs+df34y7cavs3viieiWDTUYAeUkfTiuNzDAzHoDA4E33P0Zd3+1gjbGAGvc/RV33wHcDUwwMwNOAu4N9e4EzgrPJ4TXhPfHhfoTgLvdfbu7rwXWhPal3i1dmnYPRNJV6saYGZVYEHL314GbgXXARmCru5e6P+wXzOw5M3vQzD4dyoYB62N1NoSyfYG33X1Xp/IO64T3t4b6hdrqwMwuNLNlZrasra2trJ9XEjZG/ytIk5s4Me0eJCLJw3GDiUYeI4EDgEFmdl6RVZ4GDnb3zwC3AffnmspT14uUd3ed9gL329291d1bh+r22vUhXzZfJTCVZvLAA2n3IBFJHo47GVjr7m3uvpPotuDHFKrs7u+4+7bw/FdAnzBxYQMwPFb1QOAN4C1gn3CoL15OfJ3w/t7A5iJtSVY16u29RTrbf/+0e5CIJIPQOmCsmQ0M52PGAXnOLkfM7GOhHmY2JvRtE/AkMCrMhOtLNLFgnkf5hn4LnB2amALk/lWYF14T3n8k1J8HTAyz50YCowCdbMg6JTCVZjBwYNo9SESS54SWEE0KeBpYEbZ1u5ldZmYbiEYhy8PN8iAKFivN7DngVmCiR3YBlwILiYLYXHd/PqxzNXCFma0hOuczK5TPAvYN5VcA14Q+PQ/MBVYBvwb+wd2rcPenPK68Eg4+OFpKsqZPh0MPjZaNZPZsmDAhWoq88EIy7cYTmE6dCvvuGy1rpKwEps2sWwlMW1o6XrHc0hJNe5TiupPAtG9f2Lmz4+vt2/PXzZLhw2HDho6v161Lrz+Svn79YMeO8us3UgJTqcCVV3ZNmbF7t0ZESZg+vWMAgmgnzfqIaPbsjgEIYP16jYia3dVXV7e9cq6nq8GISCOhEioeCR18cP7/WA86CF5T4vGiKh0JdWfklAUTJsC8eV3LzzyzYWdISZkquRC71D5QTltDhsCmTeVvs0PzGgml4+yzKysX6eyccyorl+Ywblztt3nGGYlvQiOhErp1Tqh37+gQXI7OCZVHI6F2Bx0UHYLL0Tkh6XyuuRSdE2piu3bBFVdEf0iuuEIBKCmNfLHqunVw113RIbi77lIAkmSmaHfeV6ZMiQ7BTZlSs/1II6ESdHvvGir2X9n8+XD66eXX1/daGs3MmXDJJeXXT3kf0EhIGsv995euI9LIjjwy7R4kQkFIsuGss0rXEWlkN99c2+09/jhcf320TJCCkGRD50Nx0NjnhEQ6q2VG//Hj4bjjottHHHccnJLc/T8VhCTblMBUmsWf/lSb7Tz+OCxa1LHsoYcSGxEpCEn2KYGpNIOXXqrNdh4qcNu3QuU9pCAkUq+UwFTievcuXac74glMIToUl0+h8h5SEJLs67wTNYLhw+G886L0PeedF11zJs3tssuq32bnfcYMjj22a8AZPz4qT4CCkGRbvp0o65TAVPL59rer216hfcUMFi6ExYujZMCLF0evE5LQ+E6kBortRFk+PzR3buHyyZNr2xepH5X8EzJhQs+3d+yxiY1+4jQSEqk3SmAq+VRyO5gMZVtXEBKpN5MnR+eE4oYP1yio2b35ZnXbq5Pr7BSEJLvqZCdKhBKYSi3UwXV2OickUq8mT9boR5KX8j9tGglJNqxe3bWs2MQEkUZz0UVp9yARCkKSDUuXpt0DkXT98Y9p9yARCkKSDWPGpN0DkXQtWZJ2DxKhICTZcNhhXcsaeWKCSGdbtqTdg0QoCEm21cHsHpGa+PDDtHuQCM2Ok+xT4BHJLI2EJPsaMYEpKIu21EZ8/xk3Dvr1i5Y1oiAk2daICUxBWbSlq5NOqn6bnfeXRx6BHTuipRmccALMnFn97cYoCEl2Nep1QgHxdZgAAA4/SURBVMqiLfmcfXZ12ytnP3nsMbjkEth33+puO0ZBSKTeFMuiLc2r2rdyqMTmzYmNiBSEROqNsmhLPi+/nO72f/jDRJpVEJLsatTrhJRFW2qh0v3kgAMS6YaCkGRDW1vXskY9JwTKoi1d9elT/TY7B6KTToKWlvx1//mfq799FIQkK159Ne0e1N7kydHNyTQCEoDvfjeZdt3bHw8/DLt2wfjxHeuMH5/YXVYVhCQbRoxIuwci6br4YhgypDbbWrgQFi+G6dOj5cKFiW1KQUiyYejQrmWNek5IpJBNm+Dcc2GvvaJlko49Fr75zcRGQDlK2yPZ5t7xHJACkDSyIUPaE5nec0+6famSREdCZna5mT1vZivNbI6Z9TezS81sjZm5me0Xq2tmdmt4b7mZHR17b4qZvRQeU2LlnzOzFWGdW82iv0ZmNsTMFoX6i8xscKltSIbFj2k3EqXtkbiZM5PJpJ1Cqp64xIKQmQ0DLgNa3f0IoAWYCDwOnAy81mmV04BR4XEhMDO0MwS4Hvg8MAa4PhdUQp0LY+udGsqvAR5291HAw+F1wW1IxjVi7jil7ZHOkrhY1axrqp4aS/qcUG9ggJn1BgYCb7j7M+7+ap66E4CfeuQJYB8z+zhwCrDI3Te7+xZgEXBqeG8vd/+9uzvwU+CsWFt3hud3dirPtw3JqkbMHae0PZLP229Xt71CI58aj4gSC0Lu/jpwM7AO2AhsdfeHiqwyDFgfe70hlBUr35CnHGB/d98Y+rER+IsS2+jAzC40s2Vmtqwt3/UpUh8a9Tohpe2RfPbaq/y6ha71iXvkkcrKE5Lk4bjBRCOPkcABwCAzO6/YKnnKvBvlRbtVzjrufru7t7p769B8s7JEkqS0PZLPsC7/Lxe2e3dy/aiyJA/HnQysdfc2d98J3AccU6T+BiCeq+RA4I0S5QfmKQd4M3eYLSz/VGIb9WPBArjggmgpzUlpeySfpUur216/fsXLZ87M/K0c1gFjzWxgmLU2DlhdpP484KthBttYosN3G4GFwHgzGxxGV+OBheG9d81sbGj/q8ADsbZys+imdCrPt436MHo0nHEGzJoVLY88Mu0e1bdGvk5IaXuksx07qtteoduFf/hhNBX8kkuyfSsHd18C3As8DawI27rdzC4zs9woZrmZ3RFW+RXwCrAG+HfgktDOZuBbwJPhcUMoA7gYuCOs8zLwYCj/V+BLZvYS8KXwuuA26sKCBbByZceyFSs0IspZnef/l0K5tJLIsZUGpe2RuErOCZXLvX3k069f9DrfVPAEb+Vg3gj/NSaotbXVly1blvyGLrggGgF1Nm0a3HFH1/JGVGxCwU9+AlOmdCwrVl/fa2k0N90EV19dfv3u7gMnnBCNgDo7/nh49NGymzGzp9y9tVQ9pe2pF2edVVl5sxkzJu0eiDSHSZMqK+8hjYRKqNlICKJzQCtWtL8ePRqWL6/NtutBpSObPfeEbdu6lu+xB7z7bvX6JVIPDjkEXnqp/Po9+du+777RIbicIUOivHUV0Egoi5Yvh/nzo0Nw8+c3VwDqjkKBRgFIpGc2bYIZM6JDcDNmVByAKqGRUAk1HQk1u+6e48mNiDQCkkbWq1dlo5uU/7aXOxJSFm3JPgUeaQYNOmDQ4TjJvkZMYAo1u1hQmlx8/5k6NTofNHVq7Tavw3HF6XBcDXXncFy+dRrhOx2/b0zudYLH5SUDJk6s7B5C5ewHpf5x68G+pIkJ0vgaNYFpjS8WlIz44IPy6+6/f+k65ewnNRgRKQiJ1Js5cyorl+ZwwAHl133zzepsc/786rRThIKQSL2p8cWCkhE/+1ntt3nGGYlvQueEStA5oRrSOaF2VbhYUBpMpYeZdU5IpIryJXKtkztDJqKGFwtKRuy3X/Xb7BxkpkyJ/uGZMqVm/8xpJFSCRkI1VOy/snyJXJXAVJrJAQfAxgruPJORi1U1EpJsUCJXaXbvvJN2DxKhICTZcPrpafdAJF177pl2DxKhICTZ1ch3VhXp7PLL0+5BIhSEJNs6BxwFIGlUV10FgwZ1LOtV4E/4RRcl358qURCS+tHdkY17+0OkkW3bBjfeCEcdFS137+46QccsU9k1FISkvmhkI1LcVVfBM89ES4CPPopGPvvvHy0/+ijd/lVIt3KQ+qPAI1KZmTMzNfqJ00hIRERSoyAkIiKpURASEZHUKAiJiEhqFIRERCQ1SmBagpm1Aa+l3Y8U7Qe8lXYnUtbsn0Gz//ygzwAq/wwOdvehpSopCElRZrasnEy4jazZP4Nm//lBnwEk9xnocJyIiKRGQUhERFKjICSl3J52B+pAs38Gzf7zgz4DSOgz0DkhERFJjUZCIiKSGgUhERFJjYJQkzGz4Wb2WzNbbWbPm9nXQ/kQM1tkZi+F5eBQbmZ2q5mtMbPlZnZ0rK0pof5LZjYlrZ+pu8ysxcyeMbMF4fVIM1sSfp57zKxvKO8XXq8J74+ItXFtKH/RzE5J5yfpHjPbx8zuNbMXwvfhC830PTCzy8M+sNLM5phZ/0b/DpjZj8zsT2a2MlZWtd+5mX3OzFaEdW4163yzozzcXY8megAfB44Oz/cE/gAcDtwEXBPKrwFuDM//GngQMGAssCSUDwFeCcvB4fngtH++Cj+LK4D/BywIr+cCE8PzHwAXh+eXAD8IzycC94TnhwPPAf2AkcDLQEvaP1cFP/+dwAXheV9gn2b5HgDDgLXAgNjvfmqjfweAE4CjgZWxsqr9zoGlwBfCOg8Cp5XsU9ofih7pPoAHgC8BLwIfD2UfB14Mz38ITIrVfzG8Pwn4Yay8Q716fwAHAg8DJwELwk7zFtA7vP8FYGF4vhD4QnjeO9Qz4Frg2libf65X7w9gr/BH2DqVN8X3IASh9eEPae/wHTilGb4DwIhOQagqv/Pw3gux8g71Cj10OK6JhUMKnwWWAPu7+0aAsPyLUC23s+ZsCGWFyrPi34CrgNxtKPcF3nb3XeF1/Of5888a3t8a6mf5M/gE0Ab8OBySvMPMBtEk3wN3fx24GVgHbCT6nT5Fc30Hcqr1Ox8WnncuL0pBqEmZ2R7AfwD/6O7vFKuap8yLlNc9Mzsd+JO7PxUvzlPVS7yX2c+A6L/5o4GZ7v5Z4D2iQzGFNNRnEM57TCA6hHYAMAg4LU/VRv4OlFLpz9ytz0JBqAmZWR+iADTb3e8LxW+a2cfD+x8H/hTKNwDDY6sfCLxRpDwLjgXONLNXgbuJDsn9G7CPmeVueR//ef78s4b39wY2k+3PYAOwwd2XhNf3EgWlZvkenAysdfc2d98J3AccQ3N9B3Kq9TvfEJ53Li9KQajJhNkqs4DV7v6d2FvzgNwslylE54py5V8NM2XGAlvDkH0hMN7MBof/KseHsrrn7te6+4HuPoLoJPMj7j4Z+C1wdqjW+TPIfTZnh/oeyieGmVMjgVFEJ2brnrv/EVhvZoeGonHAKprne7AOGGtmA8M+kfv5m+Y7EFOV33l4710zGxs+06/G2ios7ZNketT2ARxHNEReDjwbHn9NdHz7YeClsBwS6hvwfaJZPyuA1lhbfw+sCY/z0/7Zuvl5nEj77LhPEP0BWQP8HOgXyvuH12vC+5+Irf/P4bN5kTJmAtXTAzgKWBa+C/cTzXRqmu8B8E3gBWAl8DOiGW4N/R0A5hCdA9tJNHKZVs3fOdAaPs+Xge/RaeJLvofS9oiISGp0OE5ERFKjICQiIqlREBIRkdQoCImISGoUhEREJDUKQiIpMLP/CssRZvbf0+6PSFoUhERS4O7HhKcjgIqCUOyK/nLqtlTSdk+2JdIdCkIiRYSRygshwedKM5ttZieb2ePhXipjwv1Y7g/3XHnCzI4M634j3L/ld2b2ipldFmt3W3j6r8DxZvZsuL9NfzP7cbgnyzNm9leh/lQz+7mZzQceMrMTzexRM/uFma0ysx+YWa9c22Z2g5ktAb5gZuNCWytCf/qFen8dfrbF4d4vC2L9vt3MHgJ+Gj6Dx8zs6fA4JtQ70cz+08zmmtkfzOxfzWyymS0N2/rLGv2aJMvSvoJXDz3q+UE0UtkFjCb6p+0p4EdEV5NPIMo0cBtwfah/EvBseP4N4L+IrsTfD9gE9AnvbQvLEwkZG8LrK4Efh+efIkov05/oXjcbaL+a/UTgQ6Ir/FuARcDZ4T0HzgnP+xNlPD4kvP4p8I+x8pGhfA7tmSO+EX7O3L12BgL9w/NRwLJYH94mSuHfD3gd+GZ47+vAv6X9+9Oj/h8aCYmUttbdV7j7R8DzwMPu7kSpTEYQpUL6GYC7PwLsa2Z7h3V/6e7b3f0tosSQ+5fYVrytF4DXgEPCe4vcfXOs7lJ3f8XddxMFkeNC+W6iBLUAh4b+/yG8vpPoxmafAl5x97WhfE6nfsxz9w/C8z7Av5vZCqLUNYfH6j3p7hvdfTtRqpaHQnnusxEpSsd7RUrbHnv+Uez1R0T70K4ua7SnsI+vu5vS+1yx2yG/V2AbnV9/GAJTsfZK3XY5vq3LgTeBzxCNBj+MvVfqsxEpSiMhkZ57FJgM0XkS4C0vfo+muHeJbrOer61DgIOIEmPmM8bMRoZzQecCi/PUeQEYYWafDK+/AvxnKP+ERTc2JKxfyN7AxjAS/ArR4T+RqlAQEum5bwCtZracaKLBlOLVO1gO7DKz58zscmAG0BIOfd0DTA2HuvL5fdjeSqJbdf+icwV3/xA4H/h5aPMj4AfhUNslwK/NbDHRSGdrge3MAKaY2RNEhwY7j8hEuk1ZtEUyKIy4/sndT+9BG3u4+7Zw75fvAy+5+y3V6qNIOTQSEmle/8PMniWabLE38MOU+yNNSCMhERFJjUZCIiKSGgUhERFJjYKQiIikRkFIRERSoyAkIiKp+f9bRDN6D9/CwAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df1.plot(y='monitorid',x='monitorprogram',color='red',kind='scatter')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "columns=df1.columns\n",
    "columns=[c for c in columns if c not in['monitorid','date','monitortype','monitorport','monitortag','monitortext','monitorfile','monitorprogram','monitorjob','monitoroperator','monitorerrinfo']]\n",
    "target='monitorvar1'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(49474, 12)\n",
      "(12368, 12)\n"
     ]
    }
   ],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "train=df1.sample(frac=0.8,random_state=1)\n",
    "test=df1.iloc[~df1.index.isin(train.index)]\n",
    "print(train.shape)\n",
    "print(test.shape)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "could not convert string to float: 'TOOL LIFE OVER'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-31-677d91569eb3>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      2\u001b[0m \u001b[1;32mfrom\u001b[0m \u001b[0msklearn\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mmetrics\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mmean_squared_error\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[0mlr\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mLinearRegression\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 4\u001b[1;33m \u001b[0mlr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfit\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mtrain\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mtrain\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mtarget\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\sklearn\\linear_model\\base.py\u001b[0m in \u001b[0;36mfit\u001b[1;34m(self, X, y, sample_weight)\u001b[0m\n\u001b[0;32m    461\u001b[0m         \u001b[0mn_jobs_\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mn_jobs\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    462\u001b[0m         X, y = check_X_y(X, y, accept_sparse=['csr', 'csc', 'coo'],\n\u001b[1;32m--> 463\u001b[1;33m                          y_numeric=True, multi_output=True)\n\u001b[0m\u001b[0;32m    464\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    465\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0msample_weight\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m \u001b[1;32mand\u001b[0m \u001b[0mnp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0matleast_1d\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0msample_weight\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mndim\u001b[0m \u001b[1;33m>\u001b[0m \u001b[1;36m1\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\sklearn\\utils\\validation.py\u001b[0m in \u001b[0;36mcheck_X_y\u001b[1;34m(X, y, accept_sparse, accept_large_sparse, dtype, order, copy, force_all_finite, ensure_2d, allow_nd, multi_output, ensure_min_samples, ensure_min_features, y_numeric, warn_on_dtype, estimator)\u001b[0m\n\u001b[0;32m    717\u001b[0m                     \u001b[0mensure_min_features\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mensure_min_features\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    718\u001b[0m                     \u001b[0mwarn_on_dtype\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mwarn_on_dtype\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 719\u001b[1;33m                     estimator=estimator)\n\u001b[0m\u001b[0;32m    720\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mmulti_output\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    721\u001b[0m         y = check_array(y, 'csr', force_all_finite=True, ensure_2d=False,\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\sklearn\\utils\\validation.py\u001b[0m in \u001b[0;36mcheck_array\u001b[1;34m(array, accept_sparse, accept_large_sparse, dtype, order, copy, force_all_finite, ensure_2d, allow_nd, ensure_min_samples, ensure_min_features, warn_on_dtype, estimator)\u001b[0m\n\u001b[0;32m    534\u001b[0m         \u001b[1;31m# make sure we actually converted to numeric:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    535\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mdtype_numeric\u001b[0m \u001b[1;32mand\u001b[0m \u001b[0marray\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdtype\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mkind\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m\"O\"\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 536\u001b[1;33m             \u001b[0marray\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0marray\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mastype\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mnp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfloat64\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    537\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mallow_nd\u001b[0m \u001b[1;32mand\u001b[0m \u001b[0marray\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mndim\u001b[0m \u001b[1;33m>=\u001b[0m \u001b[1;36m3\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    538\u001b[0m             raise ValueError(\"Found array with dim %d. %s expected <= 2.\"\n",
      "\u001b[1;31mValueError\u001b[0m: could not convert string to float: 'TOOL LIFE OVER'"
     ]
    }
   ],
   "source": [
    "from sklearn.linear_model import LinearRegression\n",
    "from sklearn.metrics import mean_squared_error\n",
    "lr=LinearRegression()\n",
    "lr.fit(train[columns],train[target])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}