Dataset: AP Dataset

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

N 2015–2023 Data

@kaggle.ashtonronald_ap_dataset.n_2015_2023_data

93.8 KB
3014 rows
5 columns


CREATE TABLE n_2015_2023_data (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "energy_required_mu" DOUBLE,
  "temp" DOUBLE,
  "rain" DOUBLE
);

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

@kaggle.ashtonronald_ap_dataset.ap_powersupplyposition_2012_05_02_to_2023_05_14

295.76 KB
3944 rows
15 columns


CREATE TABLE ap_powersupplyposition_2012_05_02_to_2023_05_14 (
  "date" VARCHAR,
  "energy_required_mu" DOUBLE,
  "energy_met_mu" DOUBLE,
  "energy_mu" DOUBLE,
  "genco_thermal" DOUBLE,
  "genco_hydel" DOUBLE,
  "genco_total" DOUBLE,
  "cgs_and_purchases" DOUBLE,
  "ipps_gas" DOUBLE,
  "nces_others" DOUBLE,
  "ap_share_of_tgists" DOUBLE,
  "grand_total" DOUBLE,
  "reversible_pump_consumption" DOUBLE,
  "unrestricted_peak_demand_mw" VARCHAR,
  "deficit_surplus_mw" DOUBLE
);

Apinflationf

@kaggle.ashtonronald_ap_dataset.apinflationf

28.7 KB
3014 rows
2 columns


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

Ashish

@kaggle.ashtonronald_ap_dataset.ashish

84.86 KB
3015 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,
  "main" BIGINT,
  "sub" BIGINT,
  "energy_required_mu" DOUBLE
);

Data

@kaggle.ashtonronald_ap_dataset.data

100.11 KB
3015 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,
  "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
);

Districts

@kaggle.ashtonronald_ap_dataset.districts

7.8 KB
26 rows
8 columns


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

Fholidays

@kaggle.ashtonronald_ap_dataset.fholidays

5.58 KB
188 rows
3 columns


CREATE TABLE fholidays (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "holiday" VARCHAR
);

Finalapdata

@kaggle.ashtonronald_ap_dataset.finalapdata

80.59 KB
3015 rows
7 columns


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