Daily Electricity Price And Demand Data

Daily price, demand and weather data in Australia's second largest state

@kaggle.aramacus_electricity_demand_in_victoria_australia

Table List

1 table(115.69 KB)

Complete Dataset

@kaggle.aramacus_electricity_demand_in_victoria_australia.complete_dataset

115.69 KB
2106 rows
14 columns

date Date	demand Demand	rrp RRP	demand_pos_rrp Demand Pos RRP	rrp_positive RRP Positive	demand_neg_rrp Demand Neg RRP	rrp_negative RRP Negative	frac_at_neg_rrp Frac At Neg RRP	min_temperature Min Temperature	max_temperature Max Temperature	solar_exposure Solar Exposure	rainfall Rainfall	school_day School Day	holiday Holiday
Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	99635.03	25.63369643387471	97319.24000000002	26.41595261944092	2315.79	-7.239999999999997	0.020833334	13.3	26.9	23.6		N	Y
Fri Jan 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	129606.00999999994	33.13898756122499	121082.01499999994	38.83766097797432	8523.994999999999	-47.80977650151132	0.0625	15.4	38.8	26.8		N	N
Sat Jan 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	142300.53999999998	34.56485482908218	142300.53999999998	34.56485482908218				20	38.2	26.5		N	N
Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	104330.715	25.00556023842067	104330.715	25.00556023842067				16.3	21.4	25.2	4.2	N	N
Mon Jan 05 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	118132.19999999994	26.72417627793271	118132.19999999994	26.72417627793271				15	22	30.7		N	N
Tue Jan 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	130672.48499999994	31.282310728612853	130672.48499999994	31.282310728612853				17.7	26	31.6		N	N
Wed Jan 07 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	153514.82	48.31230937899024	149498.715	49.6397122450183	4016.105	-1.1	0.020833334	18.9	37.4	20.7		N	N
Thu Jan 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	142015.65500000006	49.11728029878114	142015.65500000006	49.11728029878114				23.1	28.2	13.5	19.4	N	N
Fri Jan 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	121801.15499999998	34.490675454596484	121801.15499999998	34.490675454596484				16.5	18	3.1	1.2	N	N
Sat Jan 10 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	103043.66000000005	20.229824895097856	103043.66000000005	20.229824895097856				13.6	21.7	5.6	5.2	N	N


CREATE TABLE complete_dataset (
  "date" TIMESTAMP,
  "demand" DOUBLE,
  "rrp" DOUBLE,
  "demand_pos_rrp" DOUBLE,
  "rrp_positive" DOUBLE,
  "demand_neg_rrp" DOUBLE,
  "rrp_negative" DOUBLE,
  "frac_at_neg_rrp" DOUBLE,
  "min_temperature" DOUBLE,
  "max_temperature" DOUBLE,
  "solar_exposure" DOUBLE,
  "rainfall" DOUBLE,
  "school_day" VARCHAR,
  "holiday" VARCHAR
);