2-Simulations_hourly.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from eppy import modeleditor\n",
    "from eppy.modeleditor import IDF\n",
    "from matplotlib import pyplot as plt\n",
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from besos import eppy_funcs as ef\n",
    "from besos import sampling\n",
    "from besos.evaluator import EvaluatorEP\n",
    "from besos.parameters import RangeParameter, FieldSelector, FilterSelector, Parameter, expand_plist, wwr, CategoryParameter, GenericSelector\n",
    "from besos.problem import EPProblem\n",
    "import matplotlib.pyplot as plt\n",
    "output_path=\"./output/simulation_hourly_2017/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#idd_file='/home/ict4bd_v2/Desktop/building/energyplus/EnergyPlus-9-0-1/Energy+.idd'\n",
    "iddfile='./energyplus/EnergyPlus-9-0-1/Energy+.idd'\n",
    "fname = './input/on_double.idf'\n",
    "weather='./input//ITA_Torino_160590_IWEC.epw'\n",
    "IDF.setiddname(iddfile)\n",
    "idf = IDF(fname,weather)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "total one area = 1084.534275140951\n"
     ]
    }
   ],
   "source": [
    "zones = idf.idfobjects[\"ZONE\"]\n",
    "total_area=0\n",
    "for i in range(len(zones)):\n",
    "    zone = zones[i]\n",
    "    area = modeleditor.zonearea(idf, zone.Name)\n",
    "    total_area=total_area+area\n",
    "\n",
    "print(\"total one area = %s\" % (total_area, ))"
   ]
  },
  {
   "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>Orientation</th>\n",
       "      <th>Insulation Thickness</th>\n",
       "      <th>Window to Wall Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>270</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Orientation  Insulation Thickness  Window to Wall Ratio\n",
       "0          270                  0.35                  0.15"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "samples_temp =[]\n",
    "samples_temp.append({'Orientation': 270,\n",
    "                     'Insulation Thickness': 0.35,#0.23\n",
    "                     'Window to Wall Ratio': 0.15,})\n",
    "samples = pd.DataFrame.from_dict(samples_temp)\n",
    "samples"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ict4bd_v2/py3/lib/python3.8/site-packages/besos-1.7.0-py3.8.egg/besos/eppy_funcs.py:108: UserWarning: idd is already set to: ./energyplus/EnergyPlus-9-0-1/Energy+.idd. It will NOT be changed to the default of: /usr/local/EnergyPlus-9-0-1/Energy+.idd.\n",
      "  warnings.warn(\n",
      "/home/ict4bd_v2/py3/lib/python3.8/site-packages/besos-1.7.0-py3.8.egg/besos/parameters.py:592: UserWarning: wwr is intended to be used with RangeParameter. Your value_descriptor is CategoryParameter(options=[0.15])\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "building = ef.get_building(fname)\n",
    "insulation = FieldSelector(class_name='Material', object_name='MW Glass Wool (rolls)_O.1445', \n",
    "                           field_name='Thickness')\n",
    "insulationPR=Parameter(selector=insulation,name='Insulation Thickness')\n",
    "\n",
    "window_to_wall = wwr(CategoryParameter([0.15])) \n",
    "\n",
    "orientation = FieldSelector(class_name='Building', field_name='North Axis')\n",
    "orientationPR = Parameter(selector=orientation, value_descriptor=CategoryParameter(options=[270]),\n",
    "                          name='Orientation')\n",
    "\n",
    "parameters = [orientationPR , window_to_wall, insulationPR]\n",
    "objectives = ['Electricity:Facility','DistrictHeating:Facility','DistrictCooling:Facility'] # these get made into `MeterReader` or `VariableReader`\n",
    "problem=EPProblem(parameters, objectives) # problem = parameters + objectives"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "evaluator = EvaluatorEP(problem, building, out_dir=output_path, err_dir=output_path,\n",
    "                        epw=weather) # evaluator = problem + building"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\n",
       "RunPeriod,\n",
       "    lab_part1 (O1-O1:31-12),    !- Name\n",
       "    1,                        !- Begin Month\n",
       "    1,                        !- Begin Day of Month\n",
       "    2017,                     !- Begin Year\n",
       "    12,                       !- End Month\n",
       "    31,                       !- End Day of Month\n",
       "    2017,                     !- End Year\n",
       "    ,                         !- Day of Week for Start Day\n",
       "    No,                       !- Use Weather File Holidays and Special Days\n",
       "    No,                       !- Use Weather File Daylight Saving Period\n",
       "    Yes,                      !- Apply Weekend Holiday Rule\n",
       "    Yes,                      !- Use Weather File Rain Indicators\n",
       "    Yes,                      !- Use Weather File Snow Indicators\n",
       "    ;                         !- Treat Weather as Actual"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#simulation 2017\n",
    "run_period = idf.idfobjects['RunPeriod'][0]\n",
    "run_period.Begin_Year = 2017\n",
    "run_period.End_Year = 2017\n",
    "run_period\n",
    "idf.idfobjects['RunPeriod'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#hourly simulation\n",
    "for i in range(len(idf.idfobjects['OUTPUT:VARIABLE'])):\n",
    "    idf.idfobjects['OUTPUT:VARIABLE'][i].Reporting_Frequency='hourly'\n",
    "for i in range(len(idf.idfobjects['OUTPUT:METER'])):\n",
    "    idf.idfobjects['OUTPUT:METER'][i].Reporting_Frequency='hourly'\n",
    "idf.idfobjects['OUTPUT:ENVIRONMENTALIMPACTFACTORS'][0].Reporting_Frequency='hourly'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Electricity:Facility  ::  50169.43 kWh\n",
      "DistrictHeating:Facility  ::  37120.58 kWh\n",
      "DistrictCooling:Facility  ::  7722.42 kWh\n"
     ]
    }
   ],
   "source": [
    "#Now we run the evaluator with the given parameters\n",
    "result = evaluator([270,0.15,0.35]) \n",
    "values = dict(zip(objectives, result))\n",
    "for key, value in values.items():\n",
    "    print(key, \" :: \", \"{0:.2f}\".format(value/3.6e6), \"kWh\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\r\n",
      "/home/ict4bd_v2/Desktop/ICT-for-Building-Design-main/energyplus/EnergyPlus-9-0-1/energyplus --weather /home/ict4bd_v2/Desktop/ICT-for-Building-Design-main/input/ITA_Torino_160590_IWEC.epw --output-directory /home/ict4bd_v2/Desktop/ICT-for-Building-Design-main/output/simulation_hourly_2017 --annual --idd ./energyplus/EnergyPlus-9-0-1/Energy+.idd --readvars /home/ict4bd_v2/Desktop/ICT-for-Building-Design-main/in.idf\r\n",
      "\n"
     ]
    }
   ],
   "source": [
    "idf.run(readvars=True,output_directory=output_path,annual= True)\n",
    "idf_data =pd.read_csv(output_path+'eplusout.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Date/Time',\n",
       " 'Environment:Site Outdoor Air Drybulb Temperature [C](Hourly)',\n",
       " 'BLOCK1:ZONE3:Zone Operative Temperature [C](Hourly)',\n",
       " 'BLOCK1:ZONE1:Zone Operative Temperature [C](Hourly)',\n",
       " 'BLOCK1:ZONE4:Zone Operative Temperature [C](Hourly)',\n",
       " 'BLOCK1:ZONE2:Zone Operative Temperature [C](Hourly)',\n",
       " 'Electricity:Facility [J](Hourly)',\n",
       " 'DistrictCooling:Facility [J](Hourly)',\n",
       " 'DistrictHeating:Facility [J](Hourly)']"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#getting required columns \n",
    "columns=['Date/Time']\n",
    "for i in idf_data.columns:\n",
    "    if ('Zone Operative Temperature' in i or 'District' in i or 'Electricity:Facility' in i or 'Drybulb' in i) and ('Hourly' in i): \n",
    "        columns=columns+[i]\n",
    "columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_columns = {'Date/Time':'Date_Time',\n",
    "              'Environment:Site Outdoor Air Drybulb Temperature [C](Hourly)':'t_out',\n",
    "              'BLOCK1:ZONE3:Zone Operative Temperature [C](Hourly)':'t_in_ZONE3',\n",
    "              'BLOCK1:ZONE1:Zone Operative Temperature [C](Hourly)':'t_in_ZONE1',\n",
    "              'BLOCK1:ZONE4:Zone Operative Temperature [C](Hourly)':'t_in_ZONE4',\n",
    "              'BLOCK1:ZONE2:Zone Operative Temperature [C](Hourly)':'t_in_ZONE2',\n",
    "              'DistrictHeating:Facility [J](Hourly)':'power_heating',\n",
    "              'DistrictCooling:Facility [J](Hourly)':'power_cooling' ,\n",
    "              'Electricity:Facility [J](Hourly)':'power_electricity'}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": false
   },
   "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>Date_Time</th>\n",
       "      <th>t_out</th>\n",
       "      <th>t_in_ZONE3</th>\n",
       "      <th>t_in_ZONE1</th>\n",
       "      <th>t_in_ZONE4</th>\n",
       "      <th>t_in_ZONE2</th>\n",
       "      <th>power_electricity</th>\n",
       "      <th>power_cooling</th>\n",
       "      <th>power_heating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01/01  01:00:00</td>\n",
       "      <td>0.925</td>\n",
       "      <td>13.881985</td>\n",
       "      <td>14.704189</td>\n",
       "      <td>13.783859</td>\n",
       "      <td>13.845197</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>01/01  02:00:00</td>\n",
       "      <td>0.650</td>\n",
       "      <td>13.407667</td>\n",
       "      <td>13.970457</td>\n",
       "      <td>13.264381</td>\n",
       "      <td>13.349967</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>01/01  03:00:00</td>\n",
       "      <td>0.850</td>\n",
       "      <td>13.093317</td>\n",
       "      <td>13.557124</td>\n",
       "      <td>12.962577</td>\n",
       "      <td>13.026059</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.990230e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>01/01  04:00:00</td>\n",
       "      <td>0.975</td>\n",
       "      <td>12.840838</td>\n",
       "      <td>13.204021</td>\n",
       "      <td>12.814173</td>\n",
       "      <td>12.830734</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.177752e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>01/01  05:00:00</td>\n",
       "      <td>1.000</td>\n",
       "      <td>12.716023</td>\n",
       "      <td>12.894248</td>\n",
       "      <td>12.702670</td>\n",
       "      <td>12.713656</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.533797e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>12/31  20:00:00</td>\n",
       "      <td>0.875</td>\n",
       "      <td>17.025859</td>\n",
       "      <td>16.643237</td>\n",
       "      <td>17.123165</td>\n",
       "      <td>17.075176</td>\n",
       "      <td>4.147716e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.158903e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>12/31  21:00:00</td>\n",
       "      <td>0.575</td>\n",
       "      <td>17.038292</td>\n",
       "      <td>16.846181</td>\n",
       "      <td>17.126960</td>\n",
       "      <td>17.087322</td>\n",
       "      <td>4.147716e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.950374e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8757</th>\n",
       "      <td>12/31  22:00:00</td>\n",
       "      <td>0.275</td>\n",
       "      <td>15.341103</td>\n",
       "      <td>16.972907</td>\n",
       "      <td>15.432559</td>\n",
       "      <td>15.400036</td>\n",
       "      <td>2.773038e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.723098e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8758</th>\n",
       "      <td>12/31  23:00:00</td>\n",
       "      <td>0.200</td>\n",
       "      <td>14.379886</td>\n",
       "      <td>17.045810</td>\n",
       "      <td>14.412993</td>\n",
       "      <td>14.420377</td>\n",
       "      <td>2.773038e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.627729e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8759</th>\n",
       "      <td>12/31  24:00:00</td>\n",
       "      <td>0.275</td>\n",
       "      <td>13.751880</td>\n",
       "      <td>15.203649</td>\n",
       "      <td>13.730938</td>\n",
       "      <td>13.778794</td>\n",
       "      <td>3.897757e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date_Time  t_out  t_in_ZONE3  t_in_ZONE1  t_in_ZONE4  t_in_ZONE2  \\\n",
       "0      01/01  01:00:00  0.925   13.881985   14.704189   13.783859   13.845197   \n",
       "1      01/01  02:00:00  0.650   13.407667   13.970457   13.264381   13.349967   \n",
       "2      01/01  03:00:00  0.850   13.093317   13.557124   12.962577   13.026059   \n",
       "3      01/01  04:00:00  0.975   12.840838   13.204021   12.814173   12.830734   \n",
       "4      01/01  05:00:00  1.000   12.716023   12.894248   12.702670   12.713656   \n",
       "...                ...    ...         ...         ...         ...         ...   \n",
       "8755   12/31  20:00:00  0.875   17.025859   16.643237   17.123165   17.075176   \n",
       "8756   12/31  21:00:00  0.575   17.038292   16.846181   17.126960   17.087322   \n",
       "8757   12/31  22:00:00  0.275   15.341103   16.972907   15.432559   15.400036   \n",
       "8758   12/31  23:00:00  0.200   14.379886   17.045810   14.412993   14.420377   \n",
       "8759   12/31  24:00:00  0.275   13.751880   15.203649   13.730938   13.778794   \n",
       "\n",
       "      power_electricity  power_cooling  power_heating  \n",
       "0          2.198661e+06            0.0   0.000000e+00  \n",
       "1          2.198661e+06            0.0   0.000000e+00  \n",
       "2          2.198661e+06            0.0   7.990230e+05  \n",
       "3          2.198661e+06            0.0   4.177752e+06  \n",
       "4          2.198661e+06            0.0   7.533797e+06  \n",
       "...                 ...            ...            ...  \n",
       "8755       4.147716e+07            0.0   8.158903e+07  \n",
       "8756       4.147716e+07            0.0   7.950374e+07  \n",
       "8757       2.773038e+07            0.0   1.723098e+07  \n",
       "8758       2.773038e+07            0.0   1.627729e+07  \n",
       "8759       3.897757e+06            0.0   0.000000e+00  \n",
       "\n",
       "[8760 rows x 9 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "idf_data=idf_data[columns]\n",
    "data = idf_data.rename(columns =df_columns)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['t_in'] = data[['t_in_ZONE3','t_in_ZONE1','t_in_ZONE4', 't_in_ZONE2']].mean(axis=1)"
   ]
  },
  {
   "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>Date_Time</th>\n",
       "      <th>t_out</th>\n",
       "      <th>power_electricity</th>\n",
       "      <th>power_cooling</th>\n",
       "      <th>power_heating</th>\n",
       "      <th>t_in</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01/01  01:00:00</td>\n",
       "      <td>0.925</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>14.053807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>01/01  02:00:00</td>\n",
       "      <td>0.650</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>13.498118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>01/01  03:00:00</td>\n",
       "      <td>0.850</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.990230e+05</td>\n",
       "      <td>13.159769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>01/01  04:00:00</td>\n",
       "      <td>0.975</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.177752e+06</td>\n",
       "      <td>12.922441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>01/01  05:00:00</td>\n",
       "      <td>1.000</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.533797e+06</td>\n",
       "      <td>12.756649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>12/31  20:00:00</td>\n",
       "      <td>0.875</td>\n",
       "      <td>4.147716e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.158903e+07</td>\n",
       "      <td>16.966859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>12/31  21:00:00</td>\n",
       "      <td>0.575</td>\n",
       "      <td>4.147716e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.950374e+07</td>\n",
       "      <td>17.024689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8757</th>\n",
       "      <td>12/31  22:00:00</td>\n",
       "      <td>0.275</td>\n",
       "      <td>2.773038e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.723098e+07</td>\n",
       "      <td>15.786651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8758</th>\n",
       "      <td>12/31  23:00:00</td>\n",
       "      <td>0.200</td>\n",
       "      <td>2.773038e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.627729e+07</td>\n",
       "      <td>15.064766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8759</th>\n",
       "      <td>12/31  24:00:00</td>\n",
       "      <td>0.275</td>\n",
       "      <td>3.897757e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>14.116315</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date_Time  t_out  power_electricity  power_cooling  \\\n",
       "0      01/01  01:00:00  0.925       2.198661e+06            0.0   \n",
       "1      01/01  02:00:00  0.650       2.198661e+06            0.0   \n",
       "2      01/01  03:00:00  0.850       2.198661e+06            0.0   \n",
       "3      01/01  04:00:00  0.975       2.198661e+06            0.0   \n",
       "4      01/01  05:00:00  1.000       2.198661e+06            0.0   \n",
       "...                ...    ...                ...            ...   \n",
       "8755   12/31  20:00:00  0.875       4.147716e+07            0.0   \n",
       "8756   12/31  21:00:00  0.575       4.147716e+07            0.0   \n",
       "8757   12/31  22:00:00  0.275       2.773038e+07            0.0   \n",
       "8758   12/31  23:00:00  0.200       2.773038e+07            0.0   \n",
       "8759   12/31  24:00:00  0.275       3.897757e+06            0.0   \n",
       "\n",
       "      power_heating       t_in  \n",
       "0      0.000000e+00  14.053807  \n",
       "1      0.000000e+00  13.498118  \n",
       "2      7.990230e+05  13.159769  \n",
       "3      4.177752e+06  12.922441  \n",
       "4      7.533797e+06  12.756649  \n",
       "...             ...        ...  \n",
       "8755   8.158903e+07  16.966859  \n",
       "8756   7.950374e+07  17.024689  \n",
       "8757   1.723098e+07  15.786651  \n",
       "8758   1.627729e+07  15.064766  \n",
       "8759   0.000000e+00  14.116315  \n",
       "\n",
       "[8760 rows x 6 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=data.drop(['t_in_ZONE3', 't_in_ZONE1', 't_in_ZONE4','t_in_ZONE2'], axis = 1)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>Date_Time</th>\n",
       "      <th>t_out</th>\n",
       "      <th>power_electricity</th>\n",
       "      <th>power_cooling</th>\n",
       "      <th>power_heating</th>\n",
       "      <th>t_in</th>\n",
       "      <th>temp_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017/01/01  01:00:00</td>\n",
       "      <td>0.925</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>14.053807</td>\n",
       "      <td>13.128807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017/01/01  02:00:00</td>\n",
       "      <td>0.650</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>13.498118</td>\n",
       "      <td>12.848118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017/01/01  03:00:00</td>\n",
       "      <td>0.850</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.990230e+05</td>\n",
       "      <td>13.159769</td>\n",
       "      <td>12.309769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017/01/01  04:00:00</td>\n",
       "      <td>0.975</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.177752e+06</td>\n",
       "      <td>12.922441</td>\n",
       "      <td>11.947441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017/01/01  05:00:00</td>\n",
       "      <td>1.000</td>\n",
       "      <td>2.198661e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.533797e+06</td>\n",
       "      <td>12.756649</td>\n",
       "      <td>11.756649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>2017/12/31  20:00:00</td>\n",
       "      <td>0.875</td>\n",
       "      <td>4.147716e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.158903e+07</td>\n",
       "      <td>16.966859</td>\n",
       "      <td>16.091859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>2017/12/31  21:00:00</td>\n",
       "      <td>0.575</td>\n",
       "      <td>4.147716e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.950374e+07</td>\n",
       "      <td>17.024689</td>\n",
       "      <td>16.449689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8757</th>\n",
       "      <td>2017/12/31  22:00:00</td>\n",
       "      <td>0.275</td>\n",
       "      <td>2.773038e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.723098e+07</td>\n",
       "      <td>15.786651</td>\n",
       "      <td>15.511651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8758</th>\n",
       "      <td>2017/12/31  23:00:00</td>\n",
       "      <td>0.200</td>\n",
       "      <td>2.773038e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.627729e+07</td>\n",
       "      <td>15.064766</td>\n",
       "      <td>14.864766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8759</th>\n",
       "      <td>2017/12/31  23:59:59</td>\n",
       "      <td>0.275</td>\n",
       "      <td>3.897757e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>14.116315</td>\n",
       "      <td>13.841315</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Date_Time  t_out  power_electricity  power_cooling  \\\n",
       "0     2017/01/01  01:00:00  0.925       2.198661e+06            0.0   \n",
       "1     2017/01/01  02:00:00  0.650       2.198661e+06            0.0   \n",
       "2     2017/01/01  03:00:00  0.850       2.198661e+06            0.0   \n",
       "3     2017/01/01  04:00:00  0.975       2.198661e+06            0.0   \n",
       "4     2017/01/01  05:00:00  1.000       2.198661e+06            0.0   \n",
       "...                    ...    ...                ...            ...   \n",
       "8755  2017/12/31  20:00:00  0.875       4.147716e+07            0.0   \n",
       "8756  2017/12/31  21:00:00  0.575       4.147716e+07            0.0   \n",
       "8757  2017/12/31  22:00:00  0.275       2.773038e+07            0.0   \n",
       "8758  2017/12/31  23:00:00  0.200       2.773038e+07            0.0   \n",
       "8759  2017/12/31  23:59:59  0.275       3.897757e+06            0.0   \n",
       "\n",
       "      power_heating       t_in  temp_diff  \n",
       "0      0.000000e+00  14.053807  13.128807  \n",
       "1      0.000000e+00  13.498118  12.848118  \n",
       "2      7.990230e+05  13.159769  12.309769  \n",
       "3      4.177752e+06  12.922441  11.947441  \n",
       "4      7.533797e+06  12.756649  11.756649  \n",
       "...             ...        ...        ...  \n",
       "8755   8.158903e+07  16.966859  16.091859  \n",
       "8756   7.950374e+07  17.024689  16.449689  \n",
       "8757   1.723098e+07  15.786651  15.511651  \n",
       "8758   1.627729e+07  15.064766  14.864766  \n",
       "8759   0.000000e+00  14.116315  13.841315  \n",
       "\n",
       "[8760 rows x 7 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['temp_diff'] =data['t_in'] - data['t_out']\n",
    "data['Date_Time'] = '2017/' + data['Date_Time'].str.strip()\n",
    "data['Date_Time'] = data['Date_Time'].str.replace('24:00:00','23:59:59')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "#converting from J to kWh\n",
    "data['power_heating'] /= 3.6e6\n",
    "data['power_cooling'] /= 3.6e6\n",
    "data['power_electricity'] /= 3.6e6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Date_Time</th>\n",
       "      <th>t_out</th>\n",
       "      <th>power_electricity</th>\n",
       "      <th>power_cooling</th>\n",
       "      <th>power_heating</th>\n",
       "      <th>t_in</th>\n",
       "      <th>temp_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017/01/01  01:00:00</td>\n",
       "      <td>0.925</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>14.053807</td>\n",
       "      <td>13.128807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017/01/01  02:00:00</td>\n",
       "      <td>0.650</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>13.498118</td>\n",
       "      <td>12.848118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017/01/01  03:00:00</td>\n",
       "      <td>0.850</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.221951</td>\n",
       "      <td>13.159769</td>\n",
       "      <td>12.309769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017/01/01  04:00:00</td>\n",
       "      <td>0.975</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.160487</td>\n",
       "      <td>12.922441</td>\n",
       "      <td>11.947441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017/01/01  05:00:00</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.092721</td>\n",
       "      <td>12.756649</td>\n",
       "      <td>11.756649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>2017/12/31  20:00:00</td>\n",
       "      <td>0.875</td>\n",
       "      <td>11.521435</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.663619</td>\n",
       "      <td>16.966859</td>\n",
       "      <td>16.091859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>2017/12/31  21:00:00</td>\n",
       "      <td>0.575</td>\n",
       "      <td>11.521435</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.084372</td>\n",
       "      <td>17.024689</td>\n",
       "      <td>16.449689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8757</th>\n",
       "      <td>2017/12/31  22:00:00</td>\n",
       "      <td>0.275</td>\n",
       "      <td>7.702884</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.786383</td>\n",
       "      <td>15.786651</td>\n",
       "      <td>15.511651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8758</th>\n",
       "      <td>2017/12/31  23:00:00</td>\n",
       "      <td>0.200</td>\n",
       "      <td>7.702884</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.521469</td>\n",
       "      <td>15.064766</td>\n",
       "      <td>14.864766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8759</th>\n",
       "      <td>2017/12/31  23:59:59</td>\n",
       "      <td>0.275</td>\n",
       "      <td>1.082710</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>14.116315</td>\n",
       "      <td>13.841315</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Date_Time  t_out  power_electricity  power_cooling  \\\n",
       "0     2017/01/01  01:00:00  0.925           0.610739            0.0   \n",
       "1     2017/01/01  02:00:00  0.650           0.610739            0.0   \n",
       "2     2017/01/01  03:00:00  0.850           0.610739            0.0   \n",
       "3     2017/01/01  04:00:00  0.975           0.610739            0.0   \n",
       "4     2017/01/01  05:00:00  1.000           0.610739            0.0   \n",
       "...                    ...    ...                ...            ...   \n",
       "8755  2017/12/31  20:00:00  0.875          11.521435            0.0   \n",
       "8756  2017/12/31  21:00:00  0.575          11.521435            0.0   \n",
       "8757  2017/12/31  22:00:00  0.275           7.702884            0.0   \n",
       "8758  2017/12/31  23:00:00  0.200           7.702884            0.0   \n",
       "8759  2017/12/31  23:59:59  0.275           1.082710            0.0   \n",
       "\n",
       "      power_heating       t_in  temp_diff  \n",
       "0          0.000000  14.053807  13.128807  \n",
       "1          0.000000  13.498118  12.848118  \n",
       "2          0.221951  13.159769  12.309769  \n",
       "3          1.160487  12.922441  11.947441  \n",
       "4          2.092721  12.756649  11.756649  \n",
       "...             ...        ...        ...  \n",
       "8755      22.663619  16.966859  16.091859  \n",
       "8756      22.084372  17.024689  16.449689  \n",
       "8757       4.786383  15.786651  15.511651  \n",
       "8758       4.521469  15.064766  14.864766  \n",
       "8759       0.000000  14.116315  13.841315  \n",
       "\n",
       "[8760 rows x 7 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['total_power'] = data['power_heating']+ data['power_cooling']\n",
    "data = data[['Date_Time','t_in','t_out','temp_diff','power_heating','power_cooling','power_electricity','total_power']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv(path_or_buf=output_path+'simulation_data_hourly.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date_Time</th>\n",
       "      <th>t_in</th>\n",
       "      <th>t_out</th>\n",
       "      <th>temp_diff</th>\n",
       "      <th>power_heating</th>\n",
       "      <th>power_cooling</th>\n",
       "      <th>power_electricity</th>\n",
       "      <th>total_power</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017/01/01  01:00:00</td>\n",
       "      <td>14.053807</td>\n",
       "      <td>0.925</td>\n",
       "      <td>13.128807</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017/01/01  02:00:00</td>\n",
       "      <td>13.498118</td>\n",
       "      <td>0.650</td>\n",
       "      <td>12.848118</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017/01/01  03:00:00</td>\n",
       "      <td>13.159769</td>\n",
       "      <td>0.850</td>\n",
       "      <td>12.309769</td>\n",
       "      <td>0.221951</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>0.221951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017/01/01  04:00:00</td>\n",
       "      <td>12.922441</td>\n",
       "      <td>0.975</td>\n",
       "      <td>11.947441</td>\n",
       "      <td>1.160487</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>1.160487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017/01/01  05:00:00</td>\n",
       "      <td>12.756649</td>\n",
       "      <td>1.000</td>\n",
       "      <td>11.756649</td>\n",
       "      <td>2.092721</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.610739</td>\n",
       "      <td>2.092721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>2017/12/31  20:00:00</td>\n",
       "      <td>16.966859</td>\n",
       "      <td>0.875</td>\n",
       "      <td>16.091859</td>\n",
       "      <td>22.663619</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.521435</td>\n",
       "      <td>22.663619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>2017/12/31  21:00:00</td>\n",
       "      <td>17.024689</td>\n",
       "      <td>0.575</td>\n",
       "      <td>16.449689</td>\n",
       "      <td>22.084372</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.521435</td>\n",
       "      <td>22.084372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8757</th>\n",
       "      <td>2017/12/31  22:00:00</td>\n",
       "      <td>15.786651</td>\n",
       "      <td>0.275</td>\n",
       "      <td>15.511651</td>\n",
       "      <td>4.786383</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.702884</td>\n",
       "      <td>4.786383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8758</th>\n",
       "      <td>2017/12/31  23:00:00</td>\n",
       "      <td>15.064766</td>\n",
       "      <td>0.200</td>\n",
       "      <td>14.864766</td>\n",
       "      <td>4.521469</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.702884</td>\n",
       "      <td>4.521469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8759</th>\n",
       "      <td>2017/12/31  23:59:59</td>\n",
       "      <td>14.116315</td>\n",
       "      <td>0.275</td>\n",
       "      <td>13.841315</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.082710</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Date_Time       t_in  t_out  temp_diff  power_heating  \\\n",
       "0     2017/01/01  01:00:00  14.053807  0.925  13.128807       0.000000   \n",
       "1     2017/01/01  02:00:00  13.498118  0.650  12.848118       0.000000   \n",
       "2     2017/01/01  03:00:00  13.159769  0.850  12.309769       0.221951   \n",
       "3     2017/01/01  04:00:00  12.922441  0.975  11.947441       1.160487   \n",
       "4     2017/01/01  05:00:00  12.756649  1.000  11.756649       2.092721   \n",
       "...                    ...        ...    ...        ...            ...   \n",
       "8755  2017/12/31  20:00:00  16.966859  0.875  16.091859      22.663619   \n",
       "8756  2017/12/31  21:00:00  17.024689  0.575  16.449689      22.084372   \n",
       "8757  2017/12/31  22:00:00  15.786651  0.275  15.511651       4.786383   \n",
       "8758  2017/12/31  23:00:00  15.064766  0.200  14.864766       4.521469   \n",
       "8759  2017/12/31  23:59:59  14.116315  0.275  13.841315       0.000000   \n",
       "\n",
       "      power_cooling  power_electricity  total_power  \n",
       "0               0.0           0.610739     0.000000  \n",
       "1               0.0           0.610739     0.000000  \n",
       "2               0.0           0.610739     0.221951  \n",
       "3               0.0           0.610739     1.160487  \n",
       "4               0.0           0.610739     2.092721  \n",
       "...             ...                ...          ...  \n",
       "8755            0.0          11.521435    22.663619  \n",
       "8756            0.0          11.521435    22.084372  \n",
       "8757            0.0           7.702884     4.786383  \n",
       "8758            0.0           7.702884     4.521469  \n",
       "8759            0.0           1.082710     0.000000  \n",
       "\n",
       "[8760 rows x 8 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}