Hourly Electricity Generation, Demand, Load Shedding, and Fuel Mix Dataset for Bangladesh (2015–2026)

Description

This dataset contains hourly electricity statistics for Bangladesh, compiled from the Power Grid Company of Bangladesh (PGCB) public ERP portal by running a custom Python script. It covers the period from April 2015 to March 2026, consisting of approximately 92,000+ hourly records. Each record includes national generation and demand figures, load shedding values, fuel-source disaggregation (gas, liquid fuel, coal, hydro, solar, wind), and cross-border electricity imports from India (Bheramara HVDC, Tripura, Adani) and Nepal. Column Description: datetime - Date and time of observation in ISO 8601 format (Asia/Dhaka, UTC+6) (YYYY-MM-DD HH:MM:SS) generation_mw - Total national electricity generation dispatched to the grid at the recorded hour (Megawatt (MW)) demand_mw - Recorded national electricity demand (observed consumption, not true latent demand — subject to supply-side censoring during load shedding periods) (Megawatt (MW)) load_shedding - Estimated load shedding deficit — difference between actual demand and supply available at the recorded hour (Megawatt (MW)) gas - Electricity generation from natural gas-fired power plants (Megawatt (MW)) liquid_fuel - Electricity generation from liquid fuel-fired power plants (HFO, diesel, furnace oil) (Megawatt (MW)) coal - Electricity generation from coal-fired power plants (Megawatt (MW)) hydro - Electricity generation from hydroelectric sources (primarily Kaptai Dam, Rangamati) (Megawatt (MW)) solar - Electricity generation from grid-connected solar photovoltaic installations (Megawatt (MW)) wind - Electricity generation from grid-connected wind power installations (Megawatt (MW)) india_bheramara_hvdc - Cross-border electricity import from India via the Bheramara HVDC interconnection (West Bengal) (Megawatt (MW)) india_tripura - Cross-border electricity import from India via the Tripura AC interconnection (Northeast India) (Megawatt (MW)) india_adani - Cross-border electricity import from India via the Adani-APPL dedicated transmission line (Jharkhand) (Megawatt (MW)) nepal - Cross-border electricity import from Nepal via the Bangladesh–Nepal interconnection (Megawatt (MW)) remarks - Original Bangla-language operational annotation from PGCB, translated to English. Values: Evening_Peak (সন্ধ্যা পিক) denotes evening peak demand hour; Day_Peak (ডে পিক) denotes daytime peak demand hour; blank for all other hours (Categorical (text))

Steps to reproduce

1. Navigate to https://erp.powergrid.gov.bd/w/generations/view_generations_bn 2. The site serves paginated HTML tables (~25 rows/page, ~1947 pages as of March 2026) with data in Bangla numerals (০–৯), requiring Unicode translation to ASCII digits before parsing. 3. Data was scraped programmatically using Python 3 with the following libraries: requests (HTTP GET with pagination via ?page=N), BeautifulSoup4 with lxml backend (HTML table parsing), pandas (data structuring and CSV export). 4. Bangla numerals were converted to ASCII using Python's str.maketrans(). Date and time columns were combined and parsed into ISO 8601 datetime format. 5. Duplicate datetime entries were removed, keeping the latest record. Rows with years outside 2000–2030 were discarded as parsing artifacts. To validate scraping accuracy, all 222 flagged outliers were individually cross-referenced against the live PGCB portal. All values were confirmed identical to the source, establishing 100% scraping fidelity. The anomalies represent source-level data quality issues in the original government records, which were subsequently corrected via interpolation

Institutions

• Bangladesh University of Engineering and Technology

  Dhaka Division, Dhaka

Categories

Licence