mario.parse_wiod#

mario.parse_wiod(path: str, table: str = 'IOT', year: int | None = None, country: str | None = None, add_extensions: str | None = None, row_mode: str = 'external_account', model: str = 'Database', name: str | None = None, calc_all: bool = False, **kwargs) → object#

Parse one WIOD 2016 multiregional Excel workbook from the official release.

This parser targets the multiregional WIOD 2016 Excel workbooks distributed on the official GGDC release page at https://www.rug.nl/ggdc/valuechain/wiod/wiod-2016-release?lang=en. The direct file links used there are currently:

  • MRIO IOT, current prices: https://dataverse.nl/api/access/datafile/199104

  • MRIO IOT, previous-year prices (_PYP): https://dataverse.nl/api/access/datafile/199102

  • MRIO SUT, international: https://dataverse.nl/api/access/datafile/199100

  • national IOT bundle: https://dataverse.nl/api/access/datafile/199099

  • national SUT bundle: https://dataverse.nl/api/access/datafile/199096

  • socio-economic accounts: https://dataverse.nl/api/access/datafile/199095

MARIO currently supports:

  • multiregional IOT .xlsb workbooks, including the _PYP variant;

  • multiregional SUT .xlsb workbooks;

  • national IOT .xlsx workbooks such as ITA_NIOT_nov16.xlsx;

  • national SUT .xlsx workbooks such as ITA_SUT_nov16.xlsx.

Parameters:

  • path (str) – path to one local WIOD 2016 multiregional .xlsb workbook or to a directory containing one or more WIOD 2016 multiregional workbooks.

  • table (str, optional) – choose between IOT and SUT.

  • year (int, optional) – reference year to select when path points to a directory that contains more than one WIOD 2016 workbook. For national WIOD tables, this is mandatory because one workbook contains the full time series.

  • country (str, optional) – country selector used when path points to a directory containing multiple national WIOD workbooks.

  • add_extensions (str, optional) – optional path to Socio_Economic_Accounts.xlsx. When provided, MARIO imports the socio-economic accounts as satellite extensions. For IOT tables they populate E; for SUT tables they populate Ea while leaving Ec zero-filled.

  • row_mode (str, optional) – only relevant for the international WIOD SUT workbook. Use "external_account" (default) to remove ROW from the endogenous region set and reclassify its intermediate/final-demand uses into Va and VY. Use "legacy_region" to keep the previous parser behavior where ROW stays on the commodity side of the SUT region axis. This part of the WIOD international SUT treatment should still be considered investigative because the source workbook does not provide a fully endogenous ROW economy.

  • model (str, optional) – public MARIO model class to instantiate. Database is the default and the only supported value.

  • name (str, optional) – optional dataset name stored in metadata.

  • calc_all (bool, optional) – whether to materialize derived blocks immediately after parsing.

On this page