# disco_billed_energy_latest.csv Methodology

## Source
- **File**: `ELECTRICITY_DATA_2015-Q2_2024.xlsx`
- **Document**: Nigeria Electricity Report (Q2 2024) – Energy Billed/Electricity Supply by DisCo
- **Publisher**: National Bureau of Statistics (NBS)
- **URL/Path**: `C:\Users\HP\palmgrove\NEFDB\datasets\grid_electricity\ELECTRICITY_DATA_2015-Q2_2024.xlsx`

## Sheet used
- **Sheet name**: `series` (matched because it contains the DisCo energy-billed series)

## Extraction steps
1. Read the sheet with no header to preserve the multi-section layout.
2. Locate the `ENERGY BILLED/ELECTRICITY SUPPLY (GWh)` section header (row index 64).
3. The date row is row index 65; the data block starts at row index 66 with `DISCOS` total followed by the eleven DisCos.
4. Identify the `Q2` column (column index 115 in the section header row); in a file covering through Q2 2024 this represents **Q2 2024**.
5. Extract each DisCo row value in GWh.
6. Normalize raw names (e.g., `ABUJA (AEDC)` → `AEDC`) to the canonical eleven DisCo codes.
7. Drop the `DISCOS` aggregate row.

## Sanity checks
- Missing expected DisCos: none
- Unrecognized DisCos: ['DISCOS']
- Duplicate normalized DisCos: 0 rows
- Negative/zero values: 0

## Confidence
high