Name: AP Dataset
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

AP Dataset

The following dataset was prepared to facilitate energy demand forecasting for the state of Andhra Pradesh, India. The dataset contains multiple columns(conventionally used for energy demand forecast) from the period of 1st January, 2019 to 14th May, 2023.

Tables

Apinflationf

@kaggle.ashtonronald_ap_dataset.apinflationf

29.39 kB
3,014 rows
2 columns

CREATE TABLE apinflationf (
  "date" TIMESTAMP,
  "inflation" DOUBLE
);

Ap Powersupplyposition 2012–05–02 To 2023–05–14

@kaggle.ashtonronald_ap_dataset.ap_powersupplyposition_2012_05_02_to_2023_05_14

302.86 kB
3,944 rows
15 columns

CREATE TABLE ap_powersupplyposition_2012_05_02_to_2023_05_14 (
  "date" VARCHAR,
  "energy_required_mu" DOUBLE  -- Energy Required (MU),
  "energy_met_mu" DOUBLE  -- Energy Met (MU),
  "energy_mu" DOUBLE  -- Energy +/- (MU),
  "genco_thermal" DOUBLE,
  "genco_hydel" DOUBLE,
  "genco_total" DOUBLE,
  "cgs_and_purchases" DOUBLE,
  "ipps_gas" DOUBLE  -- IPPS (GAS),
  "nces_others" DOUBLE  -- NCEs \u0026 Others,
  "ap_share_of_tgists" DOUBLE,
  "grand_total" DOUBLE,
  "reversible_pump_consumption" DOUBLE,
  "unrestricted_peak_demand_mw" VARCHAR  -- Unrestricted Peak Demand (MW),
  "deficit_surplus_mw" DOUBLE  -- Deficit/Surplus (MW)
);

Ashish

@kaggle.ashtonronald_ap_dataset.ashish

86.9 kB
3,015 rows
14 columns

CREATE TABLE ashish (
  "date" TIMESTAMP,
  "temp" DOUBLE,
  "rain" DOUBLE,
  "inflation" DOUBLE,
  "friday" BIGINT,
  "saturday" BIGINT,
  "sunday" BIGINT,
  "thursday" BIGINT,
  "tuesday" BIGINT,
  "wednesday" BIGINT,
  "n_1d" BIGINT  -- 1D,
  "main" BIGINT,
  "sub" BIGINT,
  "energy_required_mu" DOUBLE  -- Energy Required (MU)
);

Data

@kaggle.ashtonronald_ap_dataset.data

102.51 kB
3,015 rows
35 columns

CREATE TABLE data (
  "date" TIMESTAMP,
  "temp" DOUBLE,
  "rain" DOUBLE,
  "inflation" DOUBLE,
  "friday" BIGINT,
  "saturday" BIGINT,
  "sunday" BIGINT,
  "thursday" BIGINT,
  "tuesday" BIGINT,
  "wednesday" BIGINT,
  "annul_closing_of_accounts_day" BIGINT,
  "babu_jagjivan_ram_jayanti" BIGINT,
  "bakrid_eid_al_adha" BIGINT  -- Bakrid / Eid Al Adha,
  "christmas_day" BIGINT,
  "diwali" BIGINT,
  "dr_ambedkar_jayanti" BIGINT,
  "eid_e_milad" BIGINT,
  "gandhi_jayanti" BIGINT,
  "ganesh_chaturthi" BIGINT,
  "good_friday" BIGINT,
  "holi" BIGINT,
  "idul_fitr" BIGINT,
  "independence_day" BIGINT,
  "janmashtami" BIGINT,
  "kanuma_panduga" BIGINT,
  "maha_ashtami" BIGINT,
  "maha_shivaratri" BIGINT,
  "makar_sankranti" BIGINT,
  "muharram" BIGINT,
  "pongal" BIGINT,
  "ram_navami" BIGINT,
  "republic_day" BIGINT,
  "ugadi" BIGINT,
  "vijaya_dashami" BIGINT,
  "energy_required_mu" DOUBLE  -- Energy Required (MU)
);

Districts

@kaggle.ashtonronald_ap_dataset.districts

7.99 kB
26 rows
8 columns

CREATE TABLE districts (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "name_of_the_district" VARCHAR,
  "headquarters" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "population" BIGINT,
  "area" BIGINT,
  "density" DOUBLE
);

Fholidays

@kaggle.ashtonronald_ap_dataset.fholidays

5.71 kB
188 rows
3 columns

CREATE TABLE fholidays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "holiday" VARCHAR
);

Finalapdata

@kaggle.ashtonronald_ap_dataset.finalapdata

82.53 kB
3,015 rows
7 columns

CREATE TABLE finalapdata (
  "date" TIMESTAMP,
  "energy_required_mu" DOUBLE  -- Energy Required (MU),
  "temp" DOUBLE,
  "rain" DOUBLE,
  "inflation" DOUBLE,
  "day" VARCHAR,
  "holiday" VARCHAR
);

N 2015–2023 Data

@kaggle.ashtonronald_ap_dataset.n_2015_2023_data

96.05 kB
3,014 rows
5 columns

CREATE TABLE n_2015_2023_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "energy_required_mu" DOUBLE  -- Energy Required (MU),
  "temp" DOUBLE,
  "rain" DOUBLE
);