Name: Power Sector Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Power Sector Data

These three companies play significant roles in India's energy sector, contributing to power generation, transmission, and distribution activities across the country. data gathered from web scraping

Tables

Consumer

@kaggle.ajithdari_power_sector_data.consumer

185.91 kB
40,000 rows
18 columns

CREATE TABLE consumer (
  "tata_hydro" DOUBLE,
  "adani_hydro" DOUBLE,
  "powerg_hydro" DOUBLE,
  "tata_solar" DOUBLE,
  "adani_solar" DOUBLE,
  "powerg_solar" DOUBLE,
  "tata_wind" DOUBLE,
  "adani_wind" DOUBLE,
  "powerg_wind" DOUBLE,
  "tata_hydro_price" DOUBLE  -- Tata-Hydro(price),
  "adani_hydro_price" DOUBLE  -- Adani-Hydro(price),
  "powerg_hydro_price" DOUBLE  -- PowerG-Hydro(price),
  "tata_solar_price" DOUBLE  -- Tata-Solar(price),
  "adani_solar_price" DOUBLE  -- Adani-Solar(price),
  "powerg_solar_price" DOUBLE  -- PowerG-Solar(price),
  "tata_wind_price" DOUBLE  -- Tata-Wind(price),
  "adani_wind_price" DOUBLE  -- Adani-Wind(price),
  "powerg_wind_price" DOUBLE  -- PowerG-Wind(price)
);

Energy

@kaggle.ajithdari_power_sector_data.energy

4.31 MB
40,000 rows
16 columns

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  -- Solar Energy - Price Elasticity Coefficient (gamma),
  "wind_energy_price_elasticity_coefficient_gamma" DOUBLE  -- Wind Energy - Price Elasticity Coefficient (gamma),
  "hydro_energy_price_elasticity_coefficient_gamma" DOUBLE  -- Hydro Energy-Price Elasticity Coefficient (gamma),
  "solar_energy_loss" DOUBLE,
  "wind_energy_loss" DOUBLE,
  "hydro_energy_energy_loss" DOUBLE,
  "nat_demand" DOUBLE,
  "holiday" BIGINT,
  "school" BIGINT
);