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:

[1]:
import pymrio
[2]:
from pathlib import Path
[3]:
oecd_storage = Path('/tmp/mrios/OECD')
[4]:
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:

[5]:
oecd_path_year = pymrio.parse_oecd(path=oecd_storage, year=2011)

Or directly specify a file to parse:

[6]:
oecd_file = pymrio.parse_oecd(path=oecd_storage / 'ICIO2018_2011.zip')
[7]:
oecd_path_year == oecd_file
[7]:
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”:

[8]:
oecd_file.factor_inputs.F.head()
[8]:
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”.