Working with the OECD - ICIO database

The OECD Inter-Country Input-Output tables (ICIO) are available on the OECD webpage.

The parsing function >parse_oecd< works for both, the 2016 and 2018 release.

The tables can either be downloaded manually (using the csv format), or the pymrio OECD automatic downloader can be used.

For example, to get the 2011 table of the 2018 release do:

import pymrio

from pathlib import Path

oecd_storage = Path("/tmp/mrios/OECD")

meta_2018_download = pymrio.download_oecd(storage_folder=oecd_storage, years=[2011])

OECD provides the data compressed in zip files. The pymrio oecd parser works with both, the compressed and unpacked version.

Parsing

To parse a single year of the database, either specify a path and year:

oecd_path_year = pymrio.parse_oecd(path=oecd_storage, year=2011)

Or directly specify a file to parse:

oecd_file = pymrio.parse_oecd(path=oecd_storage / "ICIO2018_2011.zip")

oecd_path_year == oecd_file

True

Note: The original OECD ICIO tables provide some disaggregation of the Mexican and Chinese tables for the interindustry flows. The pymrio parser automatically aggregates these into Chinese And Mexican totals. Thus, the MX1, MX2, .. and CN1, CN2, … entries are aggregated into MEX and CHN.

Currently, the parser only includes the value added and taxes data given in original file as satellite accounts. These are accessable in the extension “factor_inputs”:

oecd_file.factor_inputs.F.head()

region	ARG										...	ZAF
sector	01T03	05T06	07T08	09	10T12	13T15	16	17T18	19	20T21	...	61	62T63	64T66	68	69T82	84	85	86T88	90T96	97T98
inputtype
AUS_TAXSUB	0.121714	0.017712	0.017512	0.017816	0.001661	0.095973	0.007718	0.034678	0.128502	0.162166	...	0.402171	0.674091	0.100344	0.626509	1.373728	1.610570	0.246573	0.634604	0.333580	0.0
AUT_TAXSUB	0.073775	0.033071	0.013816	0.005258	0.078889	0.038198	0.010675	0.025981	0.015319	0.083526	...	0.079267	0.042284	0.022676	0.061500	0.165165	0.420449	0.042098	0.449250	0.072340	0.0
BEL_TAXSUB	0.185901	0.062070	0.024458	0.011260	0.148690	0.094059	0.012182	0.057137	0.061476	0.196174	...	0.117514	0.092787	0.078851	0.145796	0.394643	0.535211	0.088572	0.357782	0.092843	0.0
CAN_TAXSUB	1.190519	0.289064	0.230554	0.056490	0.455820	0.150127	0.035587	0.076343	0.871824	0.537732	...	0.111660	0.064595	0.022136	0.065346	0.174113	0.272304	0.037256	0.102510	0.086703	0.0
CHL_TAXSUB	0.800514	0.253973	0.176948	0.044563	1.024921	1.232006	0.102607	0.321750	0.381983	0.583021	...	0.006196	0.006398	0.003776	0.019049	0.029477	0.029843	0.013084	0.022314	0.009911	0.0

5 rows × 2340 columns

Handling of the data happens similar to the other databases, see for example “Exploring EXIOBASE”.