{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Campus Energy Dataset Quick Start\n", "\n", "Version 1.0 \n", "\n", "The Campus Energy Dataset is an Academic Hub dataset hosted by the OSIsoft Cloud Service (OCS, https://www.osisoft.com/solutions/cloud/vision/), a cloud-native real-time data infrastructure used to perform enterprise-wide analytics using tools and languages of the user's choice. \n", "\n", "
\n", " | Timestamp | \n", "Asset_Id | \n", "AnnualUsage | \n", "Demand_kBtu | \n", "Electricity_EUI | \n", "MonthlyUsage | \n", "Rollover Check | \n", "Rollover Count Month | \n", "Rollover Count Year | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "2018-01-01 00:00:00 | \n", "Academic Surge Building | \n", "7573665.5 | \n", "760.19775 | \n", "60.203968 | \n", "611748.94 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
1 | \n", "2018-01-01 00:30:00 | \n", "Academic Surge Building | \n", "7573654.5 | \n", "725.03925 | \n", "60.203846 | \n", "612117.20 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
2 | \n", "2018-01-01 01:00:00 | \n", "Academic Surge Building | \n", "7573643.5 | \n", "830.64404 | \n", "60.203724 | \n", "612485.50 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
3 | \n", "2018-01-01 01:30:00 | \n", "Academic Surge Building | \n", "7573632.5 | \n", "748.75460 | \n", "60.203600 | \n", "612853.75 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
4 | \n", "2018-01-01 02:00:00 | \n", "Academic Surge Building | \n", "7573622.0 | \n", "787.10240 | \n", "60.203480 | \n", "613222.00 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1484 | \n", "2018-01-31 22:00:00 | \n", "Academic Surge Building | \n", "7583340.0 | \n", "1025.57020 | \n", "60.274185 | \n", "636483.44 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
1485 | \n", "2018-01-31 22:30:00 | \n", "Academic Surge Building | \n", "7583344.5 | \n", "1053.76230 | \n", "60.274240 | \n", "636940.94 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
1486 | \n", "2018-01-31 23:00:00 | \n", "Academic Surge Building | \n", "7583348.5 | \n", "1032.89450 | \n", "60.274290 | \n", "637398.50 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
1487 | \n", "2018-01-31 23:30:00 | \n", "Academic Surge Building | \n", "7583353.0 | \n", "1074.98910 | \n", "60.274338 | \n", "637856.06 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
1488 | \n", "2018-02-01 00:00:00 | \n", "Academic Surge Building | \n", "7583357.0 | \n", "1010.92800 | \n", "60.274387 | \n", "638313.56 | \n", "0 | \n", "0.0 | \n", "0 | \n", "
1489 rows × 9 columns
\n", "\n", " | BuildingName | \n", "CAAN | \n", "Construction Date | \n", "Display Name | \n", "Latitude | \n", "Longitude | \n", "Primary Usage (Type) | \n", "Total Maintained Gross Sq. Ft. | \n", "chilledwater.Annual Cost | \n", "chilledwater.tonh Rate | \n", "electricity.Annual Cost | \n", "electricity.kWh Rate | \n", "steam.Annual Cost | \n", "steam.klb Rate | \n", "Asset_Id | \n", "Primary Usage (SF % of Total) | \n", "Building Name | \n", "Sq Ft. | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "ARCPavilion | \n", "4444 | \n", "19770301.0 | \n", "ARC Pavilion | \n", "38.541812 | \n", "-121.759624 | \n", "REC - Athletics & Recreation | \n", "171940.0 | \n", "557.0 | \n", "0.1493 | \n", "51155 | \n", "0.0687 | \n", "1500.0 | \n", "7.2552 | \n", "ARC Pavilion | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1 | \n", "AcademicSurge | \n", "4632 | \n", "19920501.0 | \n", "Academic Surge Building | \n", "38.535302 | \n", "-121.752910 | \n", "OFF - Academic / Administrative Office | \n", "127426.0 | \n", "712.0 | \n", "0.1493 | \n", "143910 | \n", "0.0687 | \n", "13562.0 | \n", "7.2552 | \n", "Academic Surge Building | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2 | \n", "ARC | \n", "4799 | \n", "20020415.0 | \n", "Activities and Recreation Center | \n", "38.542897 | \n", "-121.759644 | \n", "REC - Athletics & Recreation | \n", "158120.0 | \n", "55977.0 | \n", "0.1493 | \n", "97822 | \n", "0.0687 | \n", "25234.0 | \n", "7.2552 | \n", "Activities and Recreation Center | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
3 | \n", "AMRL | \n", "4853 | \n", "20080731.0 | \n", "Advanced Materials Research Laboratory | \n", "38.532286 | \n", "-121.758484 | \n", "LAB - Lab / Research | \n", "7560.0 | \n", "NaN | \n", "NaN | \n", "9567 | \n", "0.0687 | \n", "NaN | \n", "NaN | \n", "Advanced Materials Research Laboratory | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
4 | \n", "ATIRC | \n", "4879 | \n", "20080801.0 | \n", "Advanced Transportation Infrastructure Researc... | \n", "38.534596 | \n", "-121.794319 | \n", "LAB - Lab / Research | \n", "18955.0 | \n", "NaN | \n", "NaN | \n", "29061 | \n", "0.0687 | \n", "NaN | \n", "NaN | \n", "Advanced Transportation Infrastructure Researc... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
161 | \n", "WatershedResearch | \n", "4833 | \n", "20051024.0 | \n", "Watershed Science Facility | \n", "38.534788 | \n", "-121.752625 | \n", "LAB - Lab / Research | \n", "18391.0 | \n", "6847.0 | \n", "0.1493 | \n", "41650 | \n", "0.0687 | \n", "3452.0 | \n", "7.2552 | \n", "Watershed Science Facility | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
162 | \n", "Wellman | \n", "4050 | \n", "0.0 | \n", "0 | \n", "38.541337 | \n", "-121.751393 | \n", "0 | \n", "0.0 | \n", "32992.0 | \n", "0.1493 | \n", "11147 | \n", "0.0687 | \n", "159444.0 | \n", "7.2552 | \n", "Wellman Hall | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
163 | \n", "WHNRC | \n", "4843 | \n", "0.0 | \n", "Western Human Nutrition Research Center (WHNRC) | \n", "38.535025 | \n", "-121.766218 | \n", "LAB - Lab / Research | \n", "49941.0 | \n", "52087.0 | \n", "0.1493 | \n", "80918 | \n", "0.0687 | \n", "23547.0 | \n", "7.2552 | \n", "Western Human Nutrition Research Center (WHNRC) | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
164 | \n", "Wickson | \n", "3351 | \n", "19590501.0 | \n", "Wickson Hall | \n", "38.542042 | \n", "-121.751590 | \n", "CLS - Classroom | \n", "112937.0 | \n", "62342.0 | \n", "0.1493 | \n", "167646 | \n", "0.0687 | \n", "67190.0 | \n", "7.2552 | \n", "Wickson Hall | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
165 | \n", "Young | \n", "3266 | \n", "19400501.0 | \n", "Young Hall | \n", "38.542394 | \n", "-121.747732 | \n", "CLS - Classroom | \n", "90567.0 | \n", "35053.0 | \n", "0.1493 | \n", "58592 | \n", "0.0687 | \n", "57209.0 | \n", "7.2552 | \n", "Young Hall | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
166 rows × 18 columns
\n", "