Use ISP assumptions

nemdb bundles AEMO's Integrated System Plan (ISP) assumption workbooks and provides a convenient reader.

Read ISP data

from nemdb import ISPAssumptions

isp = ISPAssumptions()
print(isp)

This prints the list of available tables (Excel sheet names):

ISP spreadsheet, with following tables :
 - Coal prices
 - Gas prices
 - ...

print(isp.tables)
# ['Coal prices', 'Gas prices', ...]

df = isp.read_table("Coal prices")
print(df.head())

Returns a Polars DataFrame with the contents of the named sheet.

A convenience function parses the coal prices sheet into a tidy format:

from nemdb.isp.isp import read_coal_prices

coal = read_coal_prices()
print(coal.head())

Output columns: Generator, Coal Price Scenario, fy (financial year), price.

By default, nemdb uses the bundled ISP_2024.xlsx. To use a different file:

isp = ISPAssumptions("/path/to/ISP_2023.xlsx")

The bundled artefacts are located at: