{"id":135,"date":"2021-07-03T12:13:41","date_gmt":"2021-07-03T12:13:41","guid":{"rendered":"https:\/\/saveawatthour.com\/?p=135"},"modified":"2021-07-03T14:50:31","modified_gmt":"2021-07-03T14:50:31","slug":"what-is-smart-grid-data","status":"publish","type":"post","link":"https:\/\/saveawatthour.com\/index.php\/2021\/07\/03\/what-is-smart-grid-data\/","title":{"rendered":"Smart grid data and time"},"content":{"rendered":"\n<p>When talking about smart grid data it is hard to avoid the variable associated with time. A blackout occurred at a <em>specific time<\/em>; high consumption will be expected between <em>1 and 4 pm<\/em> due to extreme heat leading to more usage of HVAC; customer Smith consumes less during the <em>weekdays<\/em> than during the <em>weekends <\/em>as he is working then; pricing is higher between <em>8 and 10 pm<\/em>; etc.<\/p>\n\n\n\n<p>As such most data (energy, pricing, weather, customer behavior) is recorded against time. This sort of data where data points occur in successive order over some period of time is called a <strong>time series<\/strong>.<\/p>\n\n\n\n<p>Time series allow us to <strong>track the evolution of data over time<\/strong>, we can see how the energy consumption varies with time, how weather relates to day-night patterns, or how customers unfold their specific daily or weekly habits. This aspect is most important as it allows utilities to <strong>plan for future events<\/strong> by analyzing the time series and applying machine learning techniques to predict consumption spikes for instances.<\/p>\n\n\n\n<p>The easiest way to represent time series data is through <strong>2D plots<\/strong> where the data (vertical Y-axis) is plotted against time (horizontal X-axis) as you can see in the next image where the energy consumption (KWh) is plotted at 15-minute intervals (in this case between 16:30 and 19:00 on the 23rd of the month):<\/p>\n\n\n\n<p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"299\" class=\"wp-image-142\" style=\"width: 400px;\" src=\"https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/time-series.png\" alt=\"\" srcset=\"https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/time-series.png 395w, https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/time-series-300x224.png 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n\n\n\n<p>In a future post I will show how to load and prepare the raw data for analysis.<\/p>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style1 like-135 jlk' href='javascript:void(0)' data-task='like' data-post_id='135' data-nonce='c01566f7d1' rel='nofollow'><img class='wti-pixel' src='https:\/\/saveawatthour.com\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-135 lc'>0<\/span><\/a><\/div><\/div> <div class='status-135 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>When talking about smart grid data it is hard to avoid the variable associated with time. A blackout occurred at a specific time; high consumption will be expected between 1 and 4 pm due to extreme heat leading to more usage of HVAC; customer Smith consumes less during the weekdays than during the weekends as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4],"tags":[12,7,19],"post_formats":[],"class_list":["post-135","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","tag-data","tag-smartgrid","tag-time-series"],"aioseo_notices":[],"guten_post_layout_featured_media_urls":{"full":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data.png",864,546,false],"thumbnail":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data-150x150.png",150,150,true],"medium":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data-300x190.png",300,190,true],"medium_large":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data-768x485.png",640,404,true],"large":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data.png",640,404,false],"1536x1536":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data.png",864,546,false],"2048x2048":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data.png",864,546,false],"guten_post_layout_landscape_large":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data.png",864,546,false],"guten_post_layout_portrait_large":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data.png",864,546,false],"guten_post_layout_square_large":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data.png",864,546,false],"guten_post_layout_landscape":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data-600x400.png",600,400,true],"guten_post_layout_portrait":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data-600x546.png",600,546,true],"guten_post_layout_square":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data-600x546.png",600,546,true],"vw-blog-magazine-homepage-thumb":["https:\/\/saveawatthour.com\/wp-content\/uploads\/2021\/07\/smartgrid-data-240x145.png",240,145,true]},"_links":{"self":[{"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/posts\/135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/comments?post=135"}],"version-history":[{"count":8,"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions"}],"predecessor-version":[{"id":153,"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions\/153"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/media\/145"}],"wp:attachment":[{"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/media?parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/categories?post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/tags?post=135"},{"taxonomy":"post_format","embeddable":true,"href":"https:\/\/saveawatthour.com\/index.php\/wp-json\/wp\/v2\/post_formats?post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}