Energy Market Dataset Overview

Column

Interactive Data Table

Column

Statistic Overview

      HOEP        Market_Demand   Ontario_Demand 
 Min.   : -4.39   Min.   :13074   Min.   :10541  
 1st Qu.:  5.87   1st Qu.:16111   1st Qu.:13894  
 Median : 16.65   Median :17483   Median :15474  
 Mean   : 21.89   Mean   :17742   Mean   :15665  
 3rd Qu.: 33.42   3rd Qu.:19176   3rd Qu.:17226  
 Max.   :317.77   Max.   :24490   Max.   :23240  

Monthly Stats

Month Max_Demand Usage Cost
January 20906 12700826 407962594
February 20076 10951065 208196379
March 18462 11372420 195642321
April 18011 10578368 313777678
May 20473 10421469 136712748
June 21369 10923446 200345697
July 23046 12685321 385442871
August 21990 12688795 388149285
September 23240 11147310 333696592
October 18205 8939507 105684566

Energy Market Data Visualization

Column

Interactive Drill Down

Column

3D Visulization

Promotion Strategy Case Study

Column

Interactive Data Table

Column

Statistic Overview

variable type stat level value formatted
FNL_DESCR character missing .all 0.000000e+00 0
FNL_DESCR character complete .all 3.050000e+02 305
FNL_DESCR character n .all 3.050000e+02 305
FNL_DESCR character min .all 1.700000e+01 17
FNL_DESCR character max .all 2.800000e+01 28
FNL_DESCR character empty .all 0.000000e+00 0
FNL_DESCR character n_unique .all 6.000000e+00 6
DESCR character missing .all 0.000000e+00 0
DESCR character complete .all 3.050000e+02 305
DESCR character n .all 3.050000e+02 305
DESCR character min .all 1.900000e+01 19
DESCR character max .all 4.900000e+01 49
DESCR character empty .all 0.000000e+00 0
DESCR character n_unique .all 6.800000e+01 68
Block Offer character missing .all 0.000000e+00 0
Block Offer character complete .all 3.050000e+02 305
Block Offer character n .all 3.050000e+02 305
Block Offer character min .all 1.000000e+00 1
Block Offer character max .all 1.600000e+01 16
Block Offer character empty .all 0.000000e+00 0
Block Offer character n_unique .all 4.800000e+01 48
# Promos integer missing .all 0.000000e+00 0
# Promos integer complete .all 3.050000e+02 305
# Promos integer n .all 3.050000e+02 305
# Promos integer mean .all 3.727869e+00 3.73
# Promos integer sd .all 4.841030e+00 4.84
# Promos integer p0 .all 1.000000e+00 1
# Promos integer p25 .all 1.000000e+00 1
# Promos integer p50 .all 1.000000e+00 1
# Promos integer p75 .all 3.000000e+00 3
# Promos integer p100 .all 2.400000e+01 24
# Promos integer hist .all NA ▇▁▁▁▁▁▁▁
Inc Sales integer missing .all 0.000000e+00 0
Inc Sales integer complete .all 3.050000e+02 305
Inc Sales integer n .all 3.050000e+02 305
Inc Sales integer mean .all 1.595624e+04 15956.24
Inc Sales integer sd .all 2.646630e+04 26466.3
Inc Sales integer p0 .all -4.185000e+03 -4185
Inc Sales integer p25 .all 2.647000e+03 2647
Inc Sales integer p50 .all 7.088000e+03 7088
Inc Sales integer p75 .all 1.572200e+04 15722
Inc Sales integer p100 .all 1.430840e+05 143084
Inc Sales integer hist .all NA ▇▂▁▁▁▁▁▁
Inc GM ex SDM integer missing .all 0.000000e+00 0
Inc GM ex SDM integer complete .all 3.050000e+02 305
Inc GM ex SDM integer n .all 3.050000e+02 305
Inc GM ex SDM integer mean .all 3.834721e+02 383.47
Inc GM ex SDM integer sd .all 2.967588e+03 2967.59
Inc GM ex SDM integer p0 .all -1.335600e+04 -13356
Inc GM ex SDM integer p25 .all -6.960000e+02 -696
Inc GM ex SDM integer p50 .all 1.220000e+02 122
Inc GM ex SDM integer p75 .all 1.330000e+03 1330
Inc GM ex SDM integer p100 .all 1.500300e+04 15003
Inc GM ex SDM integer hist .all NA ▁▁▁▇▃▁▁▁
FL_SALES integer missing .all 0.000000e+00 0
FL_SALES integer complete .all 3.050000e+02 305
FL_SALES integer n .all 3.050000e+02 305
FL_SALES integer mean .all 2.808428e+04 28084.28
FL_SALES integer sd .all 3.961563e+04 39615.63
FL_SALES integer p0 .all 4.040000e+02 404
FL_SALES integer p25 .all 6.365000e+03 6365
FL_SALES integer p50 .all 1.363800e+04 13638
FL_SALES integer p75 .all 3.138900e+04 31389
FL_SALES integer p100 .all 2.166160e+05 216616
FL_SALES integer hist .all NA ▇▂▁▁▁▁▁▁
FL_MARGIN integer missing .all 0.000000e+00 0
FL_MARGIN integer complete .all 3.050000e+02 305
FL_MARGIN integer n .all 3.050000e+02 305
FL_MARGIN integer mean .all 4.666902e+03 4666.9
FL_MARGIN integer sd .all 6.597537e+03 6597.54
FL_MARGIN integer p0 .all -3.258000e+03 -3258
FL_MARGIN integer p25 .all 8.480000e+02 848
FL_MARGIN integer p50 .all 2.378000e+03 2378
FL_MARGIN integer p75 .all 5.117000e+03 5117
FL_MARGIN integer p100 .all 3.857900e+04 38579
FL_MARGIN integer hist .all NA ▇▇▁▁▁▁▁▁
Base Sales integer missing .all 0.000000e+00 0
Base Sales integer complete .all 3.050000e+02 305
Base Sales integer n .all 3.050000e+02 305
Base Sales integer mean .all 1.188601e+04 11886.01
Base Sales integer sd .all 1.519844e+04 15198.44
Base Sales integer p0 .all 0.000000e+00 0
Base Sales integer p25 .all 2.523000e+03 2523
Base Sales integer p50 .all 5.799000e+03 5799
Base Sales integer p75 .all 1.500800e+04 15008
Base Sales integer p100 .all 7.486600e+04 74866
Base Sales integer hist .all NA ▇▂▁▁▁▁▁▁
RBT_SDM_CM integer missing .all 0.000000e+00 0
RBT_SDM_CM integer complete .all 3.050000e+02 305
RBT_SDM_CM integer n .all 3.050000e+02 305
RBT_SDM_CM integer mean .all 1.725377e+02 172.54
RBT_SDM_CM integer sd .all 1.099641e+03 1099.64
RBT_SDM_CM integer p0 .all 0.000000e+00 0
RBT_SDM_CM integer p25 .all 0.000000e+00 0
RBT_SDM_CM integer p50 .all 0.000000e+00 0
RBT_SDM_CM integer p75 .all 0.000000e+00 0
RBT_SDM_CM integer p100 .all 1.294200e+04 12942
RBT_SDM_CM integer hist .all NA ▇▁▁▁▁▁▁▁
RBT_VEND integer missing .all 0.000000e+00 0
RBT_VEND integer complete .all 3.050000e+02 305
RBT_VEND integer n .all 3.050000e+02 305
RBT_VEND integer mean .all 2.374630e+03 2374.63
RBT_VEND integer sd .all 4.894496e+03 4894.5
RBT_VEND integer p0 .all 0.000000e+00 0
RBT_VEND integer p25 .all 0.000000e+00 0
RBT_VEND integer p50 .all 0.000000e+00 0
RBT_VEND integer p75 .all 2.331000e+03 2331
RBT_VEND integer p100 .all 4.024600e+04 40246
RBT_VEND integer hist .all NA ▇▁▁▁▁▁▁▁
RBT_SDM_MPP integer missing .all 0.000000e+00 0
RBT_SDM_MPP integer complete .all 3.050000e+02 305
RBT_SDM_MPP integer n .all 3.050000e+02 305
RBT_SDM_MPP integer mean .all 0.000000e+00 0
RBT_SDM_MPP integer sd .all 0.000000e+00 0
RBT_SDM_MPP integer p0 .all 0.000000e+00 0
RBT_SDM_MPP integer p25 .all 0.000000e+00 0
RBT_SDM_MPP integer p50 .all 0.000000e+00 0
RBT_SDM_MPP integer p75 .all 0.000000e+00 0
RBT_SDM_MPP integer p100 .all 0.000000e+00 0
RBT_SDM_MPP integer hist .all NA ▁▁▁▇▁▁▁▁
CSD numeric missing .all 0.000000e+00 0
CSD numeric complete .all 3.050000e+02 305
CSD numeric n .all 3.050000e+02 305
CSD numeric mean .all 2.901640e-02 0.029
CSD numeric sd .all 4.705537e-01 0.47
CSD numeric p0 .all -4.980000e+00 -4.98
CSD numeric p25 .all -9.000000e-02 -0.09
CSD numeric p50 .all 5.000000e-02 0.05
CSD numeric p75 .all 2.300000e-01 0.23
CSD numeric p100 .all 2.150000e+00 2.15
CSD numeric hist .all NA ▁▁▁▁▁▇▁▁
GM% numeric missing .all 0.000000e+00 0
GM% numeric complete .all 3.050000e+02 305
GM% numeric n .all 3.050000e+02 305
GM% numeric mean .all 2.119344e-01 0.21
GM% numeric sd .all 1.354617e-01 0.14
GM% numeric p0 .all -1.700000e-01 -0.17
GM% numeric p25 .all 1.000000e-01 0.1
GM% numeric p50 .all 2.000000e-01 0.2
GM% numeric p75 .all 3.000000e-01 0.3
GM% numeric p100 .all 5.900000e-01 0.59
GM% numeric hist .all NA ▁▂▆▇▇▅▂▁
Sales Lift character missing .all 0.000000e+00 0
Sales Lift character complete .all 3.050000e+02 305
Sales Lift character n .all 3.050000e+02 305
Sales Lift character min .all 1.000000e+00 1
Sales Lift character max .all 7.000000e+00 7
Sales Lift character empty .all 0.000000e+00 0
Sales Lift character n_unique .all 2.060000e+02 206

% Short Trips