Let’s perform an EUI calculation:

eyJsYW5ndWFnZSI6InIiLCJzYW1wbGUiOiJzcWZ0IDwtIDI1MDAwXG5rV2ggPC0gMTI3NTAwMFxua1doX3RvX2tidHUgPC0gMy40MTJcblxua2J0dSA8LSBrV2ggKiBrV2hfdG9fa2J0dVxuXG5FVUkgPC0ga2J0dSAvIHNxZnRcblxucHJpbnQoRVVJKSJ9

Perform EUI calculations for many buildings at once

eyJsYW5ndWFnZSI6InIiLCJzYW1wbGUiOiJrYnR1IDwtIGMoMTQwMDAwLCAyMDAwMDAwLCAxNTAwMDAsIDkwMDAwMClcbnNxZnQgPC0gYygxMDAwMCwgMTMwMDAwLCAxMjAwLCA4MDAwMClcbmJ1aWxkaW5nX25hbWUgPC0gYyhcIkplZmZlcnNvbiBNYXJrZXQgTGlicmFyeVwiLCBcIk11aGxlbmJlcmcgTGlicmFyeVwiLCBcIk5ZUEwgU2NpZW5jZSwgSW5kdXN0cnkgYW5kIEJ1c2luZXNzIExpYnJhcnlcIiwgXCJCcm9va2x5biBQdWJsaWMgTGlicmFyeVwiKVxuYnVpbGRpbmdfZGF0YSA9IGRhdGEuZnJhbWUoa2J0dSwgc3FmdCwgYnVpbGRpbmdfbmFtZSlcblxuI2NhbGN1bGF0ZSBFVUlcbmJ1aWxkaW5nX2RhdGEkX19fIDwtIGJ1aWxkaW5nX2RhdGEkX19fIC8gYnVpbGRpbmdfZGF0YSRfX18ifQ==

Energy Data Analysis

First, let’s take a look at our data. It is being read in from a public github account as a csv file. We need to clean the data just a tad so the dates are in the right format. This is done for you.

eyJsYW5ndWFnZSI6InIiLCJzYW1wbGUiOiIjcmVhZCBpbiB5b3VyIHV0aWxpdHkgZGF0YVxudXRpbGl0eSA8LSByZWFkLmNzdihcImh0dHBzOi8vcmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbS9NaWNoZWxlYnJhZGxleS9DVU5ZX0JQTC9tYXN0ZXIvVXRpbGl0eS5jc3ZcIilcbnV0aWxpdHkkZW5kX2RhdGUgPSBhcy5EYXRlKHV0aWxpdHkkZW5kX2RhdGUsIGZvcm1hdCA9IFwiJW0vJWQvJVlcIilcblxuIyBzZWUgdGhlIG5hbWVzIG9mIHRoZSBjb2x1bW5zIGluIG91ciBkYXRhZnJhbWVcbmNvbG5hbWVzKHV0aWxpdHkpXG5cbiMgbGV0cyB2aWV3IGp1c3QgYSBzZWN0aW9uIG9mIHRoZSBkYXRhIFxuaGVhZGVycyA9IGMoJ2VuZF9kYXRlJywgJ2Z1ZWxfdXNhZ2UnLCAnT0FUJylcbnV0aWxpdHlbaGVhZGVyc10ifQ==

Determine if there is a relationship between the two variables OAT and electricity.

eyJsYW5ndWFnZSI6InIiLCJzYW1wbGUiOiIjUmVhZCBpbiB0aGUgZGF0YVxudXRpbGl0eSA8LSByZWFkLmNzdihcImh0dHBzOi8vcmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbS9NaWNoZWxlYnJhZGxleS9DVU5ZX0JQTC9tYXN0ZXIvVXRpbGl0eS5jc3ZcIilcbnV0aWxpdHkkZW5kX2RhdGUgPSBhcy5EYXRlKHV0aWxpdHkkZW5kX2RhdGUsIGZvcm1hdCA9IFwiJW0vJWQvJVlcIilcblxuI0xpbmVhciByZWxhdGlvbnNoaXBzIHVzaW5nIE9BVFxuZnVlbF9vYXQgPC0gbG0oZnVlbF91c2FnZSB+IE9BVCwgZGF0YSA9IHV0aWxpdHkpXG5zdW1tYXJ5KGZ1ZWxfb2F0KVxuXG4jRG8gdGhlIHNhbWUgd2l0aCBlbGVjdHJpY2l0eSBiZWxvdyFcbl9fX18gPC0gbG0oX19fXyB+IE9BVCwgZGF0YSA9IHV0aWxpdHkpXG5zdW1tYXJ5KF9fX18pIn0=

Let plot the data. First, lets make a time series graph.

eyJsYW5ndWFnZSI6InIiLCJzYW1wbGUiOiIjUmVhZCBpbiB0aGUgZGF0YVxudXRpbGl0eSA8LSByZWFkLmNzdihcImh0dHBzOi8vcmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbS9NaWNoZWxlYnJhZGxleS9DVU5ZX0JQTC9tYXN0ZXIvVXRpbGl0eS5jc3ZcIilcbnV0aWxpdHkkZW5kX2RhdGUgPSBhcy5EYXRlKHV0aWxpdHkkZW5kX2RhdGUsIGZvcm1hdCA9IFwiJW0vJWQvJVlcIilcblxuI3NldCB0aGUgZGF0YVxuZGF0ZSA9IHV0aWxpdHkkZW5kX2RhdGVcbnVzYWdlID0gdXRpbGl0eSRmdWVsX3VzYWdlXG50ZW1wZXJhdHVyZSA9IHV0aWxpdHkkT0FUXG4jcGxvdCB0aGUgZGF0YVxucGxvdChkYXRlLCB1c2FnZSwgdHlwZT1cImxcIixjb2w9XCJyZWRcIilcbnBhcihuZXc9VFJVRSlcbnBsb3QoZGF0ZSwgdGVtcGVyYXR1cmUsICwgdHlwZT1cImxcIixjb2w9XCJibHVlXCIsIHhheHQ9XCJuXCIsIHlheHQ9XCJuXCIsIHhsYWI9XCJcIix5bGFiPVwiXCIpXG5heGlzKDQpXG5sZWdlbmQoXCJ0b3BsZWZ0XCIsY29sPWMoXCJyZWRcIixcImJsdWVcIiksbHR5PTEsIGxlZ2VuZD1jKFwiVXNhZ2VcIixcIlRlbXBlcmF0dXJlXCIpKSJ9

Next, choose a set-point. This is the temperature we believe a building has started to heat/cool a building a typical set-point is around 65 degrees

Then, perform Linear Regression on HDD and CDD! Do you notice a difference?

Finally, plot the data and see your results.

eyJsYW5ndWFnZSI6InIiLCJzYW1wbGUiOiIjUmVhZCBpbiB0aGUgZGF0YVxudXRpbGl0eSA8LSByZWFkLmNzdihcImh0dHBzOi8vcmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbS9NaWNoZWxlYnJhZGxleS9DVU5ZX0JQTC9tYXN0ZXIvVXRpbGl0eS5jc3ZcIilcbnV0aWxpdHkkZW5kX2RhdGUgPSBhcy5EYXRlKHV0aWxpdHkkZW5kX2RhdGUsIGZvcm1hdCA9IFwiJW0vJWQvJVlcIilcblxuI2dlbmVyYXRlIGhlYXRpbmcgZGVncmVlIGRheXMgYW5kIGNvb2xpbmcgZGVncmVlIGRheXNcbnV0aWxpdHkkSEREIDwtIGlmZWxzZSh1dGlsaXR5JE9BVCA8IF9fICwgX18gLSB1dGlsaXR5JE9BVCwgX18pXG51dGlsaXR5JENERCA8LSBpZmVsc2UodXRpbGl0eSRPQVQgPiBfXywgdXRpbGl0eSRPQVQgLSBfXywgX18pXG5cbiNUaGVuLCBwZXJmb3JtIGxpbmVhciByZWdyZXNzaW9uIG9uIEhERCBhbmQgQ0RELlxuI1doaWNoIGVuZXJneSB0eXBlIHdvdWxkIG1ha2UgdGhlIG1vc3Qgc2Vuc2UgZm9yIEhERC9DREQgYW5hbHlzaXM/XG5cbiMjIEZ1ZWxcbl9fXyA8LSBsbShmdWVsX3VzYWdlIH4gX19fLCBkYXRhID0gdXRpbGl0eSlcbnN1bW1hcnkoX19fKVxucGxvdCh1dGlsaXR5JF9fXywgdXRpbGl0eSRmdWVsX3VzYWdlKVxuYWJsaW5lKF9fXylcblxuIyMgRWxlY1xuX19fIDwtIGxtKGVsZWNfdXNhZ2UgfiBfX18sIGRhdGEgPSB1dGlsaXR5KVxuc3VtbWFyeShfX18pXG5wbG90KHV0aWxpdHkkX19fLCB1dGlsaXR5JGVsZWNfdXNhZ2UpXG5hYmxpbmUoX19fKSJ9