Daily Power Generation In India (2017-2020)

Study Daily Energy Generation in India

@kaggle.navinmundhra_daily_power_generation_in_india_20172020

Table List

3 tables(136.5 KB)

File 02

Region Cordinates

State Region Corrected

File 02

@kaggle.navinmundhra_daily_power_generation_in_india_20172020.file_02

129.23 KB
4945 rows
9 columns

index Index	date Date	region Region	thermal_generation_actual_in_mu Thermal Generation Actual (in MU)	thermal_generation_estimated_in_mu Thermal Generation Estimated (in MU)	nuclear_generation_actual_in_mu Nuclear Generation Actual (in MU)	nuclear_generation_estimated_in_mu Nuclear Generation Estimated (in MU)	hydro_generation_actual_in_mu Hydro Generation Actual (in MU)	hydro_generation_estimated_in_mu Hydro Generation Estimated (in MU)
	Fri Sep 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Northern	624.23	484.21	30.36	35.57	273.27	320.81
1	Fri Sep 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Western	1106.89	1024.33	25.17	3.81	72	21.53
2	Fri Sep 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Southern	576.66	578.55	62.73	49.8	111.57	64.78
3	Fri Sep 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Eastern	441.02	429.39			85.94	69.36
4	Fri Sep 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	NorthEastern	29.11	15.91			24.64	21.21
5	Sat Sep 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Northern	624.23	507.42	30.36	35.69	273.27	317.19
6	Sat Sep 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Western	1106.89	1050.91	25.17	3.83	72	23.97
7	Sat Sep 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Southern	576.66	562.79	62.73	52.76	111.57	59.49
8	Sat Sep 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Eastern	441.02	425.75			85.94	74.18
9	Sat Sep 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	NorthEastern	29.11	16.5			24.64	20.81


CREATE TABLE file_02 (
  "index" BIGINT,
  "date" TIMESTAMP,
  "region" VARCHAR,
  "thermal_generation_actual_in_mu" DOUBLE,
  "thermal_generation_estimated_in_mu" DOUBLE,
  "nuclear_generation_actual_in_mu" DOUBLE,
  "nuclear_generation_estimated_in_mu" DOUBLE,
  "hydro_generation_actual_in_mu" DOUBLE,
  "hydro_generation_estimated_in_mu" DOUBLE
);