Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                                        0  \\\n",
      "0         https#//brickschema.org/schema/1.0.3/BrickFrame   \n",
      "1       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "2       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "3       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "4       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "5       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "6       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "7       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "8       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "9       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "10      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "11      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "12      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "13      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "14      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "15      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "16      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "17      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "18      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "19      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "20      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "21      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "22      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "23      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "24      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "25      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "26      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "27      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "28      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "29      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "...                                                   ...   \n",
      "272098  https://brickschema.org/schema/1.0.3/Brick#Com...   \n",
      "272099   https://brickschema.org/schema/1.0.3/Brick#Alarm   \n",
      "272100  https://brickschema.org/schema/1.0.3/Brick#Status   \n",
      "272101  https://brickschema.org/schema/1.0.3/Brick#Sensor   \n",
      "272102  https://brickschema.org/schema/1.0.3/Brick#Und...   \n",
      "272103  http://buildsys.org/ontologies/SPRL#Sproul_Chi...   \n",
      "272104  http://buildsys.org/ontologies/SPRL#Sproul_Ele...   \n",
      "272105  https://brickschema.org/schema/1.0.3/Brick#Amb...   \n",
      "272106  https://brickschema.org/schema/1.0.3/Brick#Gre...   \n",
      "272107  https://brickschema.org/schema/1.0.3/Brick#Plu...   \n",
      "272108     https://brickschema.org/schema/1.0.3/Brick#RTU   \n",
      "272109  https://brickschema.org/schema/1.0.3/Brick#The...   \n",
      "272110  https://brickschema.org/schema/1.0.3/Brick#The...   \n",
      "272111  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272112  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272113  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272114  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272115  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272116  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272117  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272118  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272119  http://buildsys.org/ontologies/SPRL#SPRL.CHW.B...   \n",
      "272120  http://buildsys.org/ontologies/SPRL#SPRL.CHW.B...   \n",
      "272121  http://buildsys.org/ontologies/SPRL#SPRL.CHW.E...   \n",
      "272122        http://buildsys.org/ontologies/SPRL#chiller   \n",
      "272123  https://brickschema.org/schema/1.0.3/Brick#Ill...   \n",
      "272124  https://brickschema.org/schema/1.0.3/BrickFram...   \n",
      "272125  https://brickschema.org/schema/1.0.3/Brick#Bui...   \n",
      "272126    https://brickschema.org/schema/1.0.3/Brick#Site   \n",
      "272127           http://buildsys.org/ontologies/SPRL#SPRL   \n",
      "\n",
      "                                                        1                 2  \n",
      "0                  http://www.w3.org/2002/07/owl#Ontology  hayward-station-  \n",
      "1                     http://www.w3.org/2002/07/owl#Class  hayward-station-  \n",
      "2                     http://www.w3.org/2002/07/owl#Class  hayward-station-  \n",
      "3                     http://www.w3.org/2002/07/owl#Class  hayward-station-  \n",
      "4                     http://www.w3.org/2002/07/owl#Class  hayward-station-  \n",
      "5            http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "6            http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "7        http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "8            http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "9            http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "10           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "11           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "12           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "13       http://www.w3.org/2002/07/owl#TransitiveProperty  hayward-station-  \n",
      "14           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "15           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "16       http://www.w3.org/2002/07/owl#TransitiveProperty  hayward-station-  \n",
      "17       http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "18       http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "19       http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "20       http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "21       http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "22       http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "23       http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "24       http://www.w3.org/2002/07/owl#AnnotationProperty  hayward-station-  \n",
      "25           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "26           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "27           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "28           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "29           http://www.w3.org/2002/07/owl#ObjectProperty  hayward-station-  \n",
      "...                                                   ...               ...  \n",
      "272098                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272099                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272100                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272101                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272102                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272103  https://brickschema.org/schema/1.0.3/Brick#Ele...              sprl  \n",
      "272104  https://brickschema.org/schema/1.0.3/Brick#Bui...              sprl  \n",
      "272105                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272106                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272107                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272108                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272109                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272110                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272111       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272112       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272113       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272114       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272115       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272116       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272117       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272118       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272119  https://brickschema.org/schema/1.0.3/Brick#Chi...              sprl  \n",
      "272120  https://brickschema.org/schema/1.0.3/Brick#Chi...              sprl  \n",
      "272121  https://brickschema.org/schema/1.0.3/Brick#Eco...              sprl  \n",
      "272122  https://brickschema.org/schema/1.0.3/Brick#Chi...              sprl  \n",
      "272123                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272124       http://www.w3.org/2002/07/owl#ObjectProperty              sprl  \n",
      "272125                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272126                http://www.w3.org/2002/07/owl#Class              sprl  \n",
      "272127    https://brickschema.org/schema/1.0.3/Brick#Site              sprl  \n",
      "\n",
      "[272128 rows x 3 columns]\n"
     ]
    }
   ],
   "source": [
    "import pymortar\n",
    "import pandas as pd\n",
    "client = pymortar.Client()\n",
    "query = \"\"\"\n",
    "SELECT ?name ?type\n",
    "WHERE {\n",
    "    ?name rdf:type ?type\n",
    "};\n",
    "\"\"\"\n",
    "qresp = client.qualify([query])\n",
    "resp = client.fetch(pymortar.FetchRequest(\n",
    "    sites=qresp.sites,\n",
    "    views=[\n",
    "        pymortar.View(\n",
    "            name=\"t\",\n",
    "            definition=query,\n",
    "        )\n",
    "    ],\n",
    "    time=pymortar.TimeParams(\n",
    "        start=\"2018-01-01T00:00:00Z\",\n",
    "        end=\"2018-01-02T00:00:00Z\",\n",
    "    )\n",
    "))\n",
    "df = pd.DataFrame(resp.query('select * from t'))\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymortar.result.Result: views:1 dataframes:0 timeseries:0 vals:0>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "resp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https#//brickschema.org/schema/1.0.3/BrickFrame</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#Ontology</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#Class</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#Class</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#Class</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#Class</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#TransitiveProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#TransitiveProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#AnnotationProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/BrickFram...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#ObjectProperty</td>\n",
       "      <td>vm3a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272098</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1232_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272099</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1233A_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272100</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1233B_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272101</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1233_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272102</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1236B_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272103</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1236C_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272104</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1264_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272105</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1271_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272106</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1279_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272107</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1282_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272108</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1302_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272109</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#RM1303_room</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Room</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272110</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1100</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272111</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1113</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272112</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1121</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272113</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1127</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272114</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1131</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272115</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1135</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272116</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1151</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272117</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1153</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272118</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1162</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272119</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1163</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272120</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1165</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272121</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1202</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272122</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1202A</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272123</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#VAVRM1202B</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#VAV</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272124</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Bui...</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#Class</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272125</th>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Site</td>\n",
       "      <td>http://www.w3.org/2002/07/owl#Class</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272126</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#chiller</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Chi...</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272127</th>\n",
       "      <td>http://buildsys.org/ontologies/THUR#THUR</td>\n",
       "      <td>https://brickschema.org/schema/1.0.3/Brick#Site</td>\n",
       "      <td>thur</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>272128 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                        0  \\\n",
       "0         https#//brickschema.org/schema/1.0.3/BrickFrame   \n",
       "1       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "2       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "3       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "4       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "5       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "6       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "7       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "8       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "9       https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "10      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "11      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "12      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "13      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "14      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "15      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "16      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "17      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "18      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "19      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "20      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "21      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "22      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "23      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "24      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "25      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "26      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "27      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "28      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "29      https://brickschema.org/schema/1.0.3/BrickFram...   \n",
       "...                                                   ...   \n",
       "272098    http://buildsys.org/ontologies/THUR#RM1232_room   \n",
       "272099   http://buildsys.org/ontologies/THUR#RM1233A_room   \n",
       "272100   http://buildsys.org/ontologies/THUR#RM1233B_room   \n",
       "272101    http://buildsys.org/ontologies/THUR#RM1233_room   \n",
       "272102   http://buildsys.org/ontologies/THUR#RM1236B_room   \n",
       "272103   http://buildsys.org/ontologies/THUR#RM1236C_room   \n",
       "272104    http://buildsys.org/ontologies/THUR#RM1264_room   \n",
       "272105    http://buildsys.org/ontologies/THUR#RM1271_room   \n",
       "272106    http://buildsys.org/ontologies/THUR#RM1279_room   \n",
       "272107    http://buildsys.org/ontologies/THUR#RM1282_room   \n",
       "272108    http://buildsys.org/ontologies/THUR#RM1302_room   \n",
       "272109    http://buildsys.org/ontologies/THUR#RM1303_room   \n",
       "272110      http://buildsys.org/ontologies/THUR#VAVRM1100   \n",
       "272111      http://buildsys.org/ontologies/THUR#VAVRM1113   \n",
       "272112      http://buildsys.org/ontologies/THUR#VAVRM1121   \n",
       "272113      http://buildsys.org/ontologies/THUR#VAVRM1127   \n",
       "272114      http://buildsys.org/ontologies/THUR#VAVRM1131   \n",
       "272115      http://buildsys.org/ontologies/THUR#VAVRM1135   \n",
       "272116      http://buildsys.org/ontologies/THUR#VAVRM1151   \n",
       "272117      http://buildsys.org/ontologies/THUR#VAVRM1153   \n",
       "272118      http://buildsys.org/ontologies/THUR#VAVRM1162   \n",
       "272119      http://buildsys.org/ontologies/THUR#VAVRM1163   \n",
       "272120      http://buildsys.org/ontologies/THUR#VAVRM1165   \n",
       "272121      http://buildsys.org/ontologies/THUR#VAVRM1202   \n",
       "272122     http://buildsys.org/ontologies/THUR#VAVRM1202A   \n",
       "272123     http://buildsys.org/ontologies/THUR#VAVRM1202B   \n",
       "272124  https://brickschema.org/schema/1.0.3/Brick#Bui...   \n",
       "272125    https://brickschema.org/schema/1.0.3/Brick#Site   \n",
       "272126        http://buildsys.org/ontologies/THUR#chiller   \n",
       "272127           http://buildsys.org/ontologies/THUR#THUR   \n",
       "\n",
       "                                                        1     2  \n",
       "0                  http://www.w3.org/2002/07/owl#Ontology  vm3a  \n",
       "1                     http://www.w3.org/2002/07/owl#Class  vm3a  \n",
       "2                     http://www.w3.org/2002/07/owl#Class  vm3a  \n",
       "3                     http://www.w3.org/2002/07/owl#Class  vm3a  \n",
       "4                     http://www.w3.org/2002/07/owl#Class  vm3a  \n",
       "5            http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "6            http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "7        http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "8            http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "9            http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "10           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "11           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "12           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "13       http://www.w3.org/2002/07/owl#TransitiveProperty  vm3a  \n",
       "14           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "15           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "16       http://www.w3.org/2002/07/owl#TransitiveProperty  vm3a  \n",
       "17       http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "18       http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "19       http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "20       http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "21       http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "22       http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "23       http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "24       http://www.w3.org/2002/07/owl#AnnotationProperty  vm3a  \n",
       "25           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "26           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "27           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "28           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "29           http://www.w3.org/2002/07/owl#ObjectProperty  vm3a  \n",
       "...                                                   ...   ...  \n",
       "272098    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272099    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272100    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272101    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272102    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272103    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272104    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272105    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272106    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272107    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272108    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272109    https://brickschema.org/schema/1.0.3/Brick#Room  thur  \n",
       "272110     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272111     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272112     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272113     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272114     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272115     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272116     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272117     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272118     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272119     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272120     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272121     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272122     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272123     https://brickschema.org/schema/1.0.3/Brick#VAV  thur  \n",
       "272124                http://www.w3.org/2002/07/owl#Class  thur  \n",
       "272125                http://www.w3.org/2002/07/owl#Class  thur  \n",
       "272126  https://brickschema.org/schema/1.0.3/Brick#Chi...  thur  \n",
       "272127    https://brickschema.org/schema/1.0.3/Brick#Site  thur  \n",
       "\n",
       "[272128 rows x 3 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}