# Indonesia coal, energy transition, and global benchmark context

A compact, reproducible analysis separating Indonesian coal production and domestic coal-fired electricity from the World Bank's Australian coal price benchmark. These are distinct measures; the charts show trends, not causal effects.

## Run

Python 3 with packages already present in `.venv`:

```bash
.venv/bin/python analyze.py
```

The run reads locally stored source files and writes two CSVs and two PNGs under `outputs/`. No publication or upload occurs. To refresh sources, download the CSV and workbook from the URLs below, replacing local copies. Pink Sheet annual chart includes complete calendar years only; partial current year excluded.

## Sources and terms

- **Our World in Data (OWID), Energy dataset**: [CSV download](https://catalog.ourworldindata.org/energy/owid_energy/owid_energy.csv), [catalog and license](https://catalog.ourworldindata.org/energy_data/owid_energy). OWID catalog identifies its data as CC BY 4.0. The dataset aggregates upstream providers; third-party data can carry separate terms. Credit OWID and upstream sources; check dataset provenance before redistributing any underlying third-party material.
- **World Bank, Commodity Price Data (“Pink Sheet”), Monthly Prices**: [Excel download](https://thedocs.worldbank.org/en/doc/74e8be41ceb20fa0da750cda2f6b9e4e-0050012026/related/CMO-Historical-Data-Monthly.xlsx) (local file `world_bank_pink_sheet_2026.xlsx`, updated 3 November 2026), [World Bank dataset terms](https://www.worldbank.org/ext/en/legal/terms-conditions/datasets). World Bank terms generally specify CC BY 4.0 with attribution, while warning that some third-party data may have different terms. Credit “The World Bank: Commodity Price Data (The Pink Sheet)” and note third-party terms where applicable.
- **Policy context**: [JETP Indonesia](https://jetp-id.org/) says the partnership launched 15 November 2022, with initial US$20 billion commitment: US$10 billion pledged by IPG and US$10 billion intended to catalyze private financing via GFANZ. These are commitment/pledge amounts, not disbursement totals. Event is context only, not a variable in analysis; no causal impact inferred. The [2025 Progress Report](https://jetp-id.org/news/jetp-reports-2025) lists policy, finance, and implementation milestones and challenges.

No license is specified for this project's code. Source data licensing is separate. When uncertain about an upstream provider's exact reuse rights, retain attribution and check provider terms; this project does not claim every source component is cleared for redistribution.

Downloaded source SHA-256: `owid_energy.csv` = `9d8efc4a9b1cc2ffdfa7f7f6f1e171b2922e0be2d97c0edf2982e874357ed6de`; `world_bank_pink_sheet_2026.xlsx` = `3c8d9d8dbb48342fdbf24777c39a8ce8964cc2fd0958f72f6779e6e4ad99cde`. Dynamic sources may change on refresh.

## Research question and audience

For an energy-policy analyst or recruiter: how did Indonesian coal production and electricity mix evolve alongside the Australian coal benchmark around the launch of JETP? This is a descriptive timeline, not an evaluation of the partnership's effects.

## Recruiter-ready summary

Built a reproducible Python analysis of Indonesian coal production and coal's electricity share alongside a global price benchmark. Validated time coverage and missingness, converted monthly prices into complete-year means, and documented the 2022 JETP launch as policy context. Findings describe trends only; the analysis does not estimate policy impacts or JETP funding disbursement.

## Findings from downloaded files

- OWID Indonesia coal production covers 2000–2025 (26 annual rows): 527.96 TWh in 2000 and 4,454.13 TWh in 2025. 2025 value is not compared with price or electricity metrics as a causal relationship.
- OWID coal-fired share of electricity is available through 2024; it is 61.48% in 2024. The 2025 electricity fields are missing.
- World Bank Australian coal benchmark covers all 12 months each year, 2000–2025 in this workbook. Annual mean was nominal USD 26.25/metric tonne in 2000, peaked at USD 344.91 in 2022, then was USD 108.39 in 2025.
- Australian benchmark is not Indonesian domestic coal price, Indonesia export realization, or coal output. Pink Sheet monthly prices are nominal USD; not inflation-adjusted.

## Validation

`analyze.py` checks required columns and workbook sheet, nonempty unique annual/month keys, positive observed prices, nonnegative production, bounded electricity shares, and writes tidy annual outputs. Incomplete values remain missing, not imputed.
