Power Sector Data

Electricity Sector in India

@kaggle.ajithdari_power_sector_data

Table List

2 tables(4.28 MB)

Energy

@kaggle.ajithdari_power_sector_data.energy

4.11 MB
40000 rows
16 columns

datetime Datetime	solar_energy_generation Solar Energy Generation	wind_energy_generation Wind Energy Generation	hydro_energy_generation Hydro Energy Generation	solar_energy_consumption Solar Energy Consumption	wind_energy_consumption Wind Energy Consumption	hydro_energy_consumption Hydro Energy Consumption	solar_energy_price_elasticity_coefficient_gamma Solar Energy - Price Elasticity Coefficient (gamma)	wind_energy_price_elasticity_coefficient_gamma Wind Energy - Price Elasticity Coefficient (gamma)	hydro_energy_price_elasticity_coefficient_gamma Hydro Energy-Price Elasticity Coefficient (gamma)	solar_energy_loss Solar Energy Loss	wind_energy_loss Wind Energy Loss	hydro_energy_energy_loss Hydro Energy-energy Loss	nat_demand Nat Demand	school School
Wed Dec 02 2015 09:00:00 GMT+0000 (Coordinated Universal Time)	2.452792487	5.414824592	4.964973087	0.952709267	1.391630284	0.509366384	0.958669083	0.86702141	0.183519882	0.019456446	0.02557373	0.019174159	1386.2975	1
Wed Dec 02 2015 10:00:00 GMT+0000 (Coordinated Universal Time)	4.311693453	7.893386017	0.917803559	1.425011611	1.291345316	0.741605326	0.851929362	0.172011877	0.788636816	0.019662848	0.035003662	0.01912879	1461.9716	1
Wed Dec 02 2015 11:00:00 GMT+0000 (Coordinated Universal Time)	5.458029674	4.123039484	9.860767936	1.028213042	0.79034586	0.622515944	0.287155756	0.252945554	0.663103928	0.019847421	0.05039978	0.01910737	1484.8518	1
Wed Dec 02 2015 12:00:00 GMT+0000 (Coordinated Universal Time)	5.744043977	5.888295335	2.434391877	1.019350603	0.869846135	1.873166839	0.733218157	0.0969157	0.159049987	0.019968877	0.0769043	0.019099126	1461.6917	1
Wed Dec 02 2015 13:00:00 GMT+0000 (Coordinated Universal Time)	2.265906393	3.889059369	9.012663052	0.722557122	1.249245972	1.703463201	0.599087797	0.975244533	0.772472139	0.020013843	0.11175537	0.01917461	1489.6994	1
Wed Dec 02 2015 14:00:00 GMT+0000 (Coordinated Universal Time)	6.903823561	9.654169138	8.841232963	1.329120735	1.154199406	1.726975994	0.786268776	0.323465054	0.069514221	0.019975226	0.12567139	0.019258063	1491.8729	1
Wed Dec 02 2015 15:00:00 GMT+0000 (Coordinated Universal Time)	4.904128693	5.851224297	8.912837299	1.742823426	1.295092561	1.361658373	0.393467815	0.308502134	0.604944283	0.0199979	0.12738037	0.019410437	1442.0816	1
Wed Dec 02 2015 16:00:00 GMT+0000 (Coordinated Universal Time)	2.254326659	3.971854129	1.004649374	0.523776646	1.606825925	1.6569089	0.203841282	0.212030615	0.117093712	0.020036519	0.12121582	0.019922078	1361.5379	1
Wed Dec 02 2015 17:00:00 GMT+0000 (Coordinated Universal Time)	6.499834739	7.001027427	8.571227477	1.069322849	0.788639643	1.534012095	0.792952833	0.312459977	0.959298533	0.020242784	0.09207153	0.019853685	1272.1607	1
Wed Dec 02 2015 18:00:00 GMT+0000 (Coordinated Universal Time)	0.72739206	4.313680903	8.399500492	1.191837066	1.414567884	1.259373949	0.470118045	0.274536896	0.070862696	0.02047151	0.06463623	0.0198459	1324.2682	1


CREATE TABLE energy (
  "datetime" TIMESTAMP,
  "solar_energy_generation" DOUBLE,
  "wind_energy_generation" DOUBLE,
  "hydro_energy_generation" DOUBLE,
  "solar_energy_consumption" DOUBLE,
  "wind_energy_consumption" DOUBLE,
  "hydro_energy_consumption" DOUBLE,
  "solar_energy_price_elasticity_coefficient_gamma" DOUBLE,
  "wind_energy_price_elasticity_coefficient_gamma" DOUBLE,
  "hydro_energy_price_elasticity_coefficient_gamma" DOUBLE,
  "solar_energy_loss" DOUBLE,
  "wind_energy_loss" DOUBLE,
  "hydro_energy_energy_loss" DOUBLE,
  "nat_demand" DOUBLE,
  "holiday" BIGINT,
  "school" BIGINT
);